How to tell who has db open on a network?

[Guest]

How can I tell what user has my database open? The DB is on our network
drive.

Thanks!

 

[TC]

If you are using Access 2000 or later (ie. Jet version 4) you could try
the UserRoster thing. It should be in online help.

HTH,
TC

 

[RobFMS]

I could recommend a software tool if you are interested.

Rob Mastrostefano

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/

 

[red skelton via AccessMonster.com]

Hi,
I use a Microsft product called LDB Viewer. It will tell you everone that
has the database open.
Good Luck
Red

 

[Keith W]

How can I tell what user has my database open? The DB is on our network
drive.

The "Environ" property works for me.

Regards,
Keith.
www.keithwilby.com

 

[hilarywalker]

I think you should look for a Networking administrator, he or she has more
knowledge about administration than the programmers like us.

 

[TC]

Huh? The OP is referring to users of his Access database. How would the
network administrator know who is currently using his Access database?

TC