Users of an database

[JackKaptijn]

I have an project with a splitt database.
The data is stored in the database_be.accdb

I want to know which users are connected tot this database. Somebody got a suggestion?

 

[pr2-eugin]

You can see the laccdb file that will hold a list of all users accessing the DB, although this information will be available only when the file is in Active use.

 

[JackKaptijn]

Thanks for the reply. The solutions as quite easy.
It's a pitty that the username for all users is admin.
So I need to users the computername for identifying the user.

Jack

 

[jdraw]

You could try

VBA.Environ("computername")

as suggested by Bob Larson in other posts.

 

[TJPoorman]

I would recommend writing some sort of logging code that will tell you the user, computer, time, etc. that each instance is loaded.