A standard downside with inheriting Microsoft Entry databases from different folks is that you simply may not have the ability to get into the database with out the startup kind loading. You additionally may not have the ability to get to the database window to make any adjustments.
Now, assuming the database is not an MDE file (which is an encrypted database that you could’t modify), and the earlier developer did not tightly safe it utilizing the Consumer-Degree Safety Wizard, it’s best to have the ability to get to the database window by merely bypassing the startup routine.
Any Entry developer can specify a startup kind and even cover the database window within the database setup choices. You’ll be able to even create an AutoExec macro that runs too.
When you maintain down the SHIFT key if you first begin your database – as quickly as you double-click the icon to open it – this could bypass the startup choices and produce you proper to the database window.
If not, then the earlier developer may need taken extra steps to safe the database. However, this straightforward answer will get you into 99% of the databases you are going to come throughout.
If this does not work, one other straightforward answer you possibly can strive is creating a brand new, clean database and simply importing all the objects from the outdated database. You will get all the tables, queries, varieties, and stories (and macros/modules too if you choose them) however you will not have any of the database properties, such because the startup choices. Simply do not import the AutoExec macro if it exists.