lock and unlock design mode of Access DB by password

  • Thread starter Thread starter Azad,DH, BD
  • Start date Start date
A

Azad,DH, BD

Dear Gurus,

I can lock and unlock the design mode of Access DB from startup and then
unlock by shift key. any user who knows the unlocking system by shift key,
can unlock the design mode of Access DB and then change. But I want to lock
the db by a password, throhg which nobody can unlock the design mode of
Access DB without the password. I also want to use a logo as form & report
icon. But if I use a logo as form & report icon, then the database design
window automatically be opened in the startup. How can I get rid off that?

pls help me.

Thanx in advance.
 
You have two choices. One is to implement User Level Security and only give
certain permissions to yourself and less to others.

The second option is to create an MDE file which compiles the code in such a
way that users can't get at the design of forms, reports, and modules. They
still can mess with tables and queries though. You can not "unlock" an MDE
file. Rather you need to keep a copy of the MDB file; make changes to it;
then compile a new MDE for the users. You also must split the database or the
data in your MDB will be outdated.
 
Back
Top