By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

How to open a "Main Menu" form once *.mdb is clicked.

P: 5
Hi Friends,

I am new to access.
Just creating a simple application now.
I want to open a "Main Menu" form once *.mdb is clicked so that the user need not browse for the main menu.
Also, is there any way that i can eliminate showing the forms and just execute the access application ?

Dec 4 '06 #1
Share this Question
Share on Google+
4 Replies

Expert 5K+
P: 8,434
You need to create a macro to do your action, and save it with the name AutoExec. This will then execute when that DB is opened.

By default (can be changed) you can prevent it by holding down the shift key while the DB opens.

Be careful not to lock yourself out of your only copy of the database!
Dec 4 '06 #2

P: 5
Hi Killer42,

Thanks a lot for the response !!
It was very useful for me and worked.

Is there a way to make it as a executable so that the user should not see any tables/forms etc even without using the "SHIFT" key ?

Dec 4 '06 #3

Expert 5K+
P: 8,434
I think so. Try searching TheScripts for "shift key bypass" - this sort of subject has come up a few times.
Dec 4 '06 #4

Expert Mod 15k+
P: 31,656
There's an easier way.
If you look in Tools / Startup, there is an option to do just that as well as some other nice options.
To get a database to run straight from a shortcut, just create a shortcut to the .Mdb file itself.
In the Tools / Startup screen there options to control what a user can do.
Dec 4 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.