How do I find out who has access database open

I

irene

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
 
G

Graham R Seach

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
---------------------------
 
A

Arvin Meyer [MVP]

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
 
I

irene

Thanks for your help I have taken the easy route and looking through manage
files
 
P

(PeteCresswell)

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.
 
P

(PeteCresswell)

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...
 
P

(PeteCresswell)

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.
 
Top