Linked tables in a MDE

[Autoeng]

I am getting ready to convert my application to a MDE but I have some questions about linked tables and references.

When I distribute my application (in mdb format) I have been working on it on my computer via a copy of the front end. I put the new front end on the server and the users download it to their pc's via a batch file every time they start it up.

After I upload the front end to the server I always have to start the database directly from the server (without using the batch download file) and reset my table links and usually one reference. My understanding of an MDE is that I won't be able to set the links manually or add a reference if it is missing after the conversion. Is this correct?

If so I guess I have two solutions. Move the database to the server and reset everything, then make the MDE or code auto link and reference.

Any input is greatly appreciated.

Autoeng

 

[JonH]

You can set the links on the mde file at any time. It will save the link setting even as an mde which you can then distribute.

Jon.