Stop autoexecute View tables and queries

[John Michl]

I'm new to Access so and I think this should be a simple question/answer.

I just took over some Access apps from a someone that left our company.
When the MDB file is opened, it immediately launches a form that allows
running several reports. I can only see the form. I cannot see the other
objects that are typically seen when you open an Access file such as the
list of tables, queries, reports, forms, etc. This access app is launched
by clicking an icon in another a different, non-Access app. Another user is
able to hold down the shift key when clicking and she can get to the other
objects. This doesn't work on my machine. Two questions:

1) How can I temporarily disable the auto run of this form and see the other
apps?

2) Where is the auto run (and hiding of other objects) controlled?

Thanks

- John Michl

 

[jmonty]

If the database window is hidden, go to the Window menu
and select Unhide.
To prevent that first form from popping up, on the Tools
menu select Startup. Change the Display Form to None.
Close the database, then reopen it to allow the changes to
take affect.
**NOTE: Be careful when diabling menus from the Startup
dialog, you may just lock yourself out. Save a copy of the
DB in a different location before making changes. (I
learned the hard way).
If all else fails create a new database. On the Tables tab
click the New then Import. From here you can import all
the tables, forms, queries, etc. from the original without
all of the startup settings.
Hope this helps!

 

[John Michl]

Great. Thanks for the quick response!

If the database window is hidden, go to the Window menu
and select Unhide.
To prevent that first form from popping up, on the Tools
menu select Startup. Change the Display Form to None.
Close the database, then reopen it to allow the changes to
take affect.
**NOTE: Be careful when diabling menus from the Startup
dialog, you may just lock yourself out. Save a copy of the
DB in a different location before making changes. (I
learned the hard way).
If all else fails create a new database. On the Tables tab
click the New then Import. From here you can import all
the tables, forms, queries, etc. from the original without
all of the startup settings.
Hope this helps!

 

[Douglas J. Steele]

Hold down the Shift key while you're opening the database. Unless the
developer explicitly disabled the Bypass key, that will prevent any
processing from happening when the database is opened.