How do I lock a Access database?

[Guest]

Hi, I'd like to know if there's a way that I can make myself the only editor
of a shared database. I'd like the other users to be able to view the
information in read-only mode, no editing. Is there a way that I can do this?
I'd appreciate any help, thanks.

 

[Pat Hartman\(MVP\)]

You need to implement security. Be sure to download the Security FAQ from
the knowledgebase BEFORE you do anything. It is quite easy to get yourself
into a pickle if you do the wrong thing. Also, the first step of any
modification is -- make a backup.

 

[Guest]

First of all, you should have your database set up with the data being shared
and then the program on the workstations, linked to the data. That way you
can have two separate programs distributed. One to those who can edit and
one that cannot be. Depending on the number of forms you have for data
entry/edit, you can change one copy to not allow edits, additions or
deletions in the form properties.

There are other ways to accomplish this through logins, etc. Let us know if
you need more info.