capturing workgroup user-id in Access form

[garyruns]

Hi,

In response to your advice --

"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!!




Start your own Tek-Tips Group! Click Here!
mstrmage1768 (Programmer)
8 Jan 07 15:20
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. ""


How would I be able to capture the user-id in a form? I do not want the user to enter his user-id twice.

Thanks,
Gary

 

[PHV]

Network ID: Environ("UserName")
UserLevel secured DB ID: CurrentUser()

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