View who else is using an Access db

P

pmbauer

Hello, and thanks for reading. My user is the owner of an Access database. He
is wants to know how to see who else is using the database at any given time.
Haven't found this in the KB. Any ideas? Thanks very much.
 
A

Arvin Meyer [MVP]

If the user is a system administrator, he can look at the logs to see who is
in any file at any given time. If you are using User Level Security, you can
look in the LDB file to see who's logged in. If none of those is possible,
you'll need to record the username when he logs in, and when he logs out in
a table. You can get the username from:

http://www.mvps.org/access/api/api0008.htm

and the time in and out from the system. Use a form (which can be hidden)
when the database opens and closes to write to the table.
 
A

a a r o n . k e m p f

Instead of having to go OUTSIDE the database and gamble with the
file-- it is much better to fire a stored procedure

for example

EXEC SP_WHO

this would give you a list of anyone in the database; and it is quite
easy to close a connection using the K I L L command.

Jet isn't designed -- from the ground up - to work with multiple
users.
It would be much better for everyone if you just asked your boss for
funds to take a SQL Server class at the closest community college.
 
A

a a r o n . k e m p f

Instead of having to go OUTSIDE the database and gamble with the
file-- it is much better to fire a stored procedure

for example

EXEC SP_WHO

this would give you a list of anyone in the database; and it is quite
easy to close a connection using the K I L L command.

Jet isn't designed -- from the ground up - to work with multiple
users.
It would be much better for everyone if you just asked your boss for
funds to take a SQL Server class at the closest community college.
 
A

aaron.kempf is a robot

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.
 
A

aaron.kempf is a robot

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.
 
Top