tracking user connections

[TheDash]

Hello, Is there a way user connections can be tracked in access database. we have issues with database corruption and sometimes users do not logout when they are done. Is there a way to maintain a table that shows whoch users are logged in at a certain point in time? what is required is the windows username and machine name. Thanks.

 

[Remou]

You should be able to user Environ:

Environ("UserName")
Environ("ComputerName")

You may wish to look at:

http://www.granite.ab.ca/access/corruption/workstation.htm