Setting up database to be read-only for users

[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,

 

[Keith Wilby]

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,

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