How to detect who is accessing the database

[dollygoh]

Hi,

I am doing a multi-user database and there will definitely be more than 1 user accessing the database at the same time. How can I detect whether is there any user accessing the database ? Thanks in advance.

[Hack]

The least painful way of seeing who is currently connected to your Db is to add an admin table. In the Form_Load event, Write a record back to this table containing the userId, and date/time that they connected.

If the Form_Unload event, write another record containing the userId, and date/time they disconnected.

Warning: This table can get very full, very fast, so judicious table maintenance is a must (unless you need to know who and whattime, logged in 2 months ago)

[Beacon]

To see if there's a connection to an Access database just look for the .ldb file created in the same directory and of the same name as your database.
You can open it and it will tell you who's got the database open.

There is another way but i forget it!

good luck
b