View Single Post
  #2 (permalink)  
Old November 13th, 2003, 04:52 AM
U.N.C.L.E. U.N.C.L.E. is offline
Friend of Wrox
Points: 422, Level: 7
Points: 422, Level: 7 Points: 422, Level: 7 Points: 422, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jul 2003
Location: La Jolla, CA, USA.
Posts: 112
Thanks: 0
Thanked 0 Times in 0 Posts

First, make a backup of your database! Have you done that yet? Good.

Now, take a look at Tools|Startup menu. There is a checkbox that says "Display Database Window". This dialog controls the menus, menu items, etc. that your user will see when the database first starts up... You can play around with the various settings, but be forewarned that some people have locked themselves out of their own database playing with these settings. Which is why I strongly recommend to make a backup before "playing" with the settings.

One catch: Your user, if sophisticated enough, can bypass your startup settings by holding down the shift key when first opening your database. This will also bypass any autoexec code.

Solution: You have to set the "AllowBypassKey" property to false and add it to the database properties collection. This can only be done via VBA code.

If you're interested in digging deeper... reply appropriately.

Reply With Quote