Problem moving back-end distributed

[funderburgh]

I have a need to move the back end database of a distributed Access application to a more secure location. I have developed this application over the course of several years. I have moves the tables that are linked and updated the location in the front end. I can verify the location in the linked table manager (and the path shows when I hover over the table name.

BUT, when I rename the "old" database back end, the application will not open. Something in there is pointing to the old location, and I don't know how to find it. There are dozens of reports and forms and lots of VBA code. I am familiar with the database reporting tools but really have no idea where to start. Any thought are welcome.

 

[CJ_London]

Have you upgraded to 2007 or 2010? If so, have you set the trusted locations - see attached as a guide

Assuming all of your tables have linked OK and you haven't missed off a table along the way then if the application won't open, it sounds like it might be something in the first form to open.

If you can set the default display form to none so you can just open the db, then edit your main form in design mode to enable you to debug it - stepping through each bit of code from the OnLoad event onwards you should be able to determine where the problem lies.