User Logging / Tracking

[Rob]

Hi all,

I have been working on a DB and need to be able to have users log in to the
database for two reasons,

1) Security
2) Logging to monitor their activity.

Please give me a starting point for this. Maybe a unrelated table called
tblUsers can be used? but where do I hold the passwords etc. I havent got
any techies working for me so it doesnt need to be bulletproof. Any help
much appreciated.

 

[Neil]

Rob,

Use the built in security in Access to create group (and user if necessary)
accounts. From there, you can see who is logged on at any time by using the
built in function CurrentUser(). Relevant information can be found in the
Access help files and also on the Microsoft website - www.microsoft.com (in
the Knowledgebase).

HTH,

Neil.