Password on access

[Yael]

Hi!!
I'm working on a database that has a few tables that everyone can access. I
want to give permision to other people to see them but not to change any of
the data.
I have tried to make users and administrators but it seems to work in only
one computer...
Does someone know how to do this?

Thank u very much!!!

 

[John W. Vinson]

Hi!!
I'm working on a database that has a few tables that everyone can access. I
want to give permision to other people to see them but not to change any of
the data.
I have tried to make users and administrators but it seems to work in only
one computer...
Does someone know how to do this?

Thank u very much!!!

You should CERTAINLY have a split database, with a backend containing only the
tables, and each user getting a frontend with the code, forms, reports, etc.

With the frontend you can implement Access security (for 2003 and earlier,
they took it away in 2007). Study (CAREFULLY) the Microsoft Access 2000
Security FAQ:

http://support.microsoft.com/kb/207793/en-us