Microsoft Access 2007 - How to Change Path to Database
I have been asked to make some changes to an Access database used by a local company. The database is on a server and is in Access 2003 format (mdb). The company is using Access 2007. The previous programmer is no longer available and there is very little documentation. Now, I copied the database (delta.mdb) and the back-end database (delta_be.mdb) to my computer at home so I can work on it. When I run the database the following error message appears:
"//deltamain/orderprogram/delta_be.mdb" is not a valid path. I then went into VBA and searched for references to "delta_be.mdb" so I could change the path. But I could not find any references.
Question 1 - Can someone tell me where the path to the back-end database is stored? Perhaps it's a property of the database? I can't find it anywhere.
Question 2- Is there a way to print a list of the names of all the objects in the database. I don't want to analyze the objects, just print the names.