How can I make a database read only to other users but myself?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be the only one able to make any changes in my Access
Database. How do I go about making it read only to all users but myself?
 
Char said:
I would like to be the only one able to make any changes in my Access
Database. How do I go about making it read only to all users but
myself?
Click to expand...

I seem to recall earlier versions have a two password system that would
do just that, but it appears not to be in the XP version. It seems you will
need to go to User Level Security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Read-Only permissions make database read-only to others 3
Database Opening as Read Only 1
database has been opened read only 5
Access 2007 opens read only 0
Best way to deploy Access read-only database that is linked to SQL tables 6
MAKING DATABASE READ ONLY 1
Read Only access 2

Back
Top