MS Access Security - Restrict Records by User 3

[0212]

Hi, all! I have not been able to locate any detailed liturature on Access Security. My challenge is this:

There will be 30 or 40 users for the Access Database. The Data will reside on a Citrix Server while the Front end will reside on each user's machine. Each user is responsible for maintaining their own records or customers only. When a user logs into Access using their own user name and password, I would like to restrict access to only the records for which they are responsible. The database consists of many tables, queries and forms. However, the primary table contains a user field with which to filter. Can you point me in the right direction on how to accomplish this feat? I would prefer the information to be as detailed as possible because I am just getting my feet wet with VB. Thanks for whatever help that you can offer!!

 

[SgtJarrow]

An effective, albiet simple, method would be to add a field to each table where the users enter data to capture the ID or name of the person entering the data.

Then any query or pull from the tables should include this field as a filter clause.

This method is not foolproof, not by any means truly secure. But it will keep most casual users from seeing data they should not.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[0212]

Thanks, mstrmage1768, for your quick reply! But, how would I do this? I have a menu system set up currently. How do I capture the specific user's id when they log in. If I can capture that, I can set up the filters to key only on the id and it would be automatic following the authorized entry of the particular person. Thanks again for your help!

 

[PHV]

If the database is secured, then simply use Application.CurrentUser to retrieve the logged user name.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[0212]

Thank you, PHV! I will try it out! I have not set up the security yet. When that is completed, I will follow your and mstrmage1768's instructions.

Jim.