Question Moving Database Backend

[TastyWheat]

I have a split database that is used by many people in the office. They've gotten used to copying the frontend to their desktop but they pretty much freak out at everything else. Whenever links are broken the frontend shows an error message and stops loading the database. At the very least it would help if a custom message would pop up whenever the linked tables are missing. Is there a way I can make the move easier on the users?

 

[apr pillai]

Broken Links

With VBA you can do it. On startup attempt to open the linked tables for reading after setting On Error Resume Next statement. If the link is broken it will generate and error code. Check the variable Err is set with a number (most likely 3044) other than 0. If it is then we can assume that file's link is broken. You can check the other files also this way and gather information on all the files and display a Msgbox with details so that the User's will know about it. Ask the User to introduce the files in the respective locations before opening the Database again. At this point you can Shutdown the Database with Docmd.Quit statement.

www.msaccesstips.com

 

[TastyWheat]

Where do I put the code, in the Switchboard? I get an error before anything is loaded and the database stays closed (unless I use the SHIFT key to open it).

 

[Darth Vodka]

use a batch file to force the users to copy the front end to their local drives

 

[Oldsoftboss]

This is how I do it...

http://www.access-programmers.co.uk/forums/showthread.php?t=115344

Dave