Re: Opening codes

Goto Tools - Startup

Uncheck the "Display Database Window"

This means the Dialog box where you can click on Forms, Tables, Queries, etc
will not appear, unless you hold down the <Shift> key as you open the db.

If you do this, then obviously you have to use a series of "menu" or
"switchboard" forms to lead your users thru your database, giving them access
to whatever objects you want them to have access to. The initial form needs
to be selected, in this same place, Tools - Startup, in the "Display
Form/Page" box.

This, of course, only supplies limited security. As you've already stated,
holding <Shift> down when opening the database will show the Database Window,
as will pressing <F11> while the database is open. Security here, as most
places, depends on who/what you're trying to protect your database from. This
will work if you simply want to prevent non-Access savvy users from snooping.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200806/1

.

Relevant Pages

  • Re: No matter what I do the database window opens
    ... Ran Office Update and got notification on 6 security updates only. ... I have user and group security in place which means I see the database ... But yes the database window appears ... I have reviewed my settings repeatedly in Tools - Startup and am going to ...
    (microsoft.public.access.security)
  • Re: Protecting DB
    ... Security (ULS). ... Assigning appropriate permissions to various database objects ... startup properties for your users. ... to disable the Shift key bypass for those users who are wedgie resilient. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Opening codes
    ... Doug Steele, Microsoft Access MVP ... 'This function will disable the shift at startup causing the Autoexec ... Dim db As Database ...
    (microsoft.public.access.modulesdaovba)
  • Re: Opening codes
    ... more secure syntax shown in http://www.mvps.org/access/general/gen0040.htm ... 'This function will disable the shift at startup causing the Autoexec ... Dim db As Database ...
    (microsoft.public.access.modulesdaovba)
  • RE: Retrieve no. of forms, tables, etc. from Access DBs
    ... There are, I believe, two ways to make screens like this ... Startup code that is... ... Any of the 25000 database in the list may contain code that runs ... If so, when I run the below example in Excel, code execution ...
    (microsoft.public.access.modulesdaovba)