Record-Level Security in Access 2002

[tallbarb]

I've set up a database with user-level permissions and now the boss wants to exclude employees from seeing anything but their own records. I haven't a clue how to do this. Your help, as usual, would be very much appreciated!

 

[WB786]

This is what I have done:

1 - Create a module to get user login info
2 - Store this value in all of the records the user will be working with or updating or should have access to.
3 - All of the forms open using queries and the queries has GetUser() as one of the criteria so the user will only see their records.

Keep in mind you will have to create a column in all of your tables to hold the GetUser() info and then you will have to update all of the forms and query to utilize this as well as store the user login id when new records are created.

Let me know if you need specific information if you would like to go down this path.

WB

WB