Track the User logged in the Shared MS Access Database

[Gaurav]

Hi,
is there a way to know which user last logged in the shared Access
database.
My requirement is that I must be able to track the users that log in
the database and incase its not working because one of the user has
done something wrong that I must be able to track him/her.

TIA

-G.

[Allen Browne]

See:
HOW TO: Check Who Logged into Database with Jet UserRoster in Access
2000
at:
http://support.microsoft.com/?id=198755

You may find it easier to use your initialization code (e.g. AutoExec macro)
to actually log the users in and out. Just Execute an Append query statement
on a table set up for this purpose.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gaurav" <ga************@infosys.com> wrote in message
news:97**************************@posting.google.c om...

is there a way to know which user last logged in the shared Access
database.
My requirement is that I must be able to track the users that log in
the database and incase its not working because one of the user has
done something wrong that I must be able to track him/her.