Programming to make the db a read only

[bigdrewecu]

i was wondering if there was anyway that i can make a database in access read only to one user when they enter in a user name programmatically. The reason being is that the database is not on a server but is emailed out to 3 people thus very small.

 

[willir]

There are several ways...
Read up on using Access security - you can control rights to the table and form level.

...But Access is not super secure.

Also, if you make the database into an executable, MDE file, you have a lot more control on security. ...But you have to ensure that the MDE file is bullet proof.

I suspect Access security would probably meet your needs since it sounds like the recipients are not highly technicals.

Richard