Readonly Security on db objects to everyone except 3 usernames (1 Viewer)

[MsLady]

I am pretty new to access security and would like to implement one into a small database i have just created.
This datbase is located on the network.
I want only 3 users (by their username) to have read/write access to the tables in the database.
Everyother object should be locked.
Everyother person should only have read access to the objects.


How do i achieve this with code? or anyother way of achieving this.
open to suggestions. Please help.

 

[MsLady]

*ahem

 

[MsLady]

.....anyone?

 

[Mark Rock]

I saw a post on this somewhere. It suggested you read / utilize the environment information to pull out the user's name

I assume you then check the current user's name against a table of users allowed to edit.

Edited to include link: Thread discussing getting a username from the environment