How do I find out who has access database open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database which is shared how do I find out who actually has
it open so I can contact them to close to allow me to open the database
 
Irene,

Unless you write your own code to track users, the only way I know of is to
use JETROSTER.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
irene said:
I have an access database which is shared how do I find out who actually has
it open so I can contact them to close to allow me to open the database
Click to expand...

As Doug mentioned, without user-level security, you can't get the Access
username. You can, however, get the Windows username:

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

you can also log on to the server as an admin and right-click on My
Computer, choose manage and check who has any file open. If you want to kick
a user off, you can do it then. If you don't have srver permissions, you can
kick a user off by using my code at:

http://www.datastrat.com/Code/KickEmOff.txt

There is a sample database with this code at:

http://www.datastrat.com/Download/KickEm.zip

You shouldn't need to close a database for multiple users though. Make sure
that each users Options are set for shared opening. Also, make sure your
database is split and each user has a copy of the front-end on their
workstation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Per Arvin Meyer [MVP]:
you can also log on to the server as an admin and right-click on My
Computer, choose manage and check who has any file open.
Click to expand...

Would that be Computer Management|Shared Folders|Open Files... or is there some
other tool?

Recently files named like CMLS--2005-12-05--08-23-08.log have started appearing
in my temp directory and I cannot delete them ("...source or destination file
may be in use...").

I'd *really* like to find out what's creating them and drive a stake through
it's heart.
 
Per (PeteCresswell):
I'd *really* like to find out what's creating them and drive a stake through
it's heart.
Click to expand...

Oops, found it: a process called aolsoftware.exe.

Starts up when AOL's AIM client is started.

Hmmmm... gotta wonder what it's logging... Have to check it's contents after
somebody's used AIM later on today...
 
Per Arvin Meyer [MVP]:
That's the one I use.
Click to expand...

Then it sounds like aolsoftware.exe is doing some sort of end run. Computer
Management|Shared Folders|Open Files shows nothing open yet the log file in
question cannot be deleted until I open up TaskMan and manually kill the process
aolsoftware.exe - after that, the file can be deleted... so I'm assuming that
process was the one that had it open; unless the term "open" has some wiggle
room built into it.
 
Back
Top