How to prevent users from viewing Database Window?

[BobV]

Group:

How do I prevent users from opening my application by holding down the shift
key and bypassing my opening code that prevents the user from viewing the
tables, forms, queries and reports? I have password protected by VBA
modules, so they can't view my code, but I would also like to prevent them
from viewing the database window (tables, forms, reports, queries, etc.). Is
there a setting that I can change to password protect the viewing of the
database window, or to prevent them from bypassing my code?

Thanks,
BobV

 

[Douglas J. Steele]

Well, you can prevent them from bypassing your startup code by setting the
AllowBypassKey property of the database (see
http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for the
proper way of doing this). However, unless you apply Access Security,
there's nothing you can do that will prevent them from importing objects
from your
database into a new database.

 

[BobV]

Doug:

Once again, thanks for your help!

BobV

Well, you can prevent them from bypassing your startup code by setting the
AllowBypassKey property of the database (see
http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for the
proper way of doing this). However, unless you apply Access Security,
there's nothing you can do that will prevent them from importing objects
from your
database into a new database.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



etc.).