Setting up database to be read-only for users

  • Thread starter Thread starter SeekerFan
  • Start date Start date
S

SeekerFan

I'm getting ready to deploy my database out to my users. How do I set it up
so that it automatically opens in read-only format for users? And can I
create a button that will allow me to enter a password and log in as the
administrator?
Thank you,
 
SeekerFan said:
I'm getting ready to deploy my database out to my users. How do I set it
up
so that it automatically opens in read-only format for users? And can I
create a button that will allow me to enter a password and log in as the
administrator?
Thank you,
Click to expand...

Sounds like you want to set up user-level security. You can only do that if
you're not using the A2007 file type, ie if you *do* use the mdb file
format. There's a link to the FAQ on my web site but beware, user-level
security is complex and has a steep learning curve. Be sure to work on
copies of your files in case you lock yourself out. The only thing easy
about security is the ability to lock yourself out!

Good luck.

Keith.
www.keithwilby.co.uk
 
Back
Top