Question User-level security Access 2003

[gkl]

Dear All,

I am using the user-level security in Access 2003 and manage to have different users and logins for each of the database users. My question is whether that functionality creates a login log so that if I am an admin for the database I can see who logged on when and what changes he/she made to the database.

Regards,
George

 

[RuralGuy]

I'm by no means an expert with ULS but I'm pretty sure it does not have those features. You would need to do them yourself.

 

[spikepl]

Further to RuralGuy's info: Audit Trail are the terms to search for in combination with Access. For users logged in, the word is roster and there is some code you can find using google to show who is in the db.

 

[LeonDavies]

Hello, just thought I'd add my thoughts for my first post.

During my start up routine I wrote a record to a log table indicating the status of the login (was the user logged in, did it fail because their account was locked etc). I used my own user table but the principle of an "access"log table is the same...feel free to let me know if you'd like to know more

 

[apr pillai]

Check the following links:

1. Who is Online
2. Who Changed the Data
3. Database Open/Close Event alerts