Hi - I have a front end database that is linked to 2 backend databases. I'd like to add code so that after the splashscreen pops up it checks to see if the front end is linked. If not then asks the user to enter the path for the two backend databases. I need your HELP!!1

Bukaw

You have to loop through the tables and check if there's a conneciton string. If so, refreshlink.
Then If Err>0 then Newpath = inputbox(enter path to database)
Connect to Newpath and refreshlink.
Then If Err>0 ....

Or instead of the input box you could use Application.FileDialog(msoFileDialogFilePicker)

enjoy!