access options ms access 2007

Question

hi

does anyone know how to disable the access-options or to hide it?

Thanks

additional info:

hi again if you open your ms access 2007, you usually see the button at the upper left -"the microsoft office button" and if you click on that, you'll see the different functions like: "new", "save", "open" etc and at the button you'll see the "access options" and "exit

Answer 1

Presumably this is only for the users. You can create a shortcut which the users use on their desktops which has the /runtime command line option. The problem though is you then have to add the path and file name of the msaccess.exe file, ie "C:\Program Files....\msaccess.exe"

Using the free Auto FE Updater makes this entire process a lot easier as well as automatically updating the FE as you make updates available to the users.

Answer 2

Make a ACCDE copy of the DB This will Strip out your VB source (but will leave the compiled code intact). but first get your menu setting the way you want e.g.
1. click Access Options->Current Database.
2. Uncheck "Enable Full Menus" for this database
3. From the Database Tools menu, choose "Make ACCDE"

Note Unless you apply a valid digital signature to you DB, Access will warn about VB script and prompt user to Open or cancel good thing is it will quit if they don't accept run VB script but its better to create a digital signature for your DB

Hope this helps