Home All Groups Group Topic Archive Search About

How to tell who has db open on a network?

Author
14 Nov 2005 6:41 PM
naiveprogrammer
How can I tell what user has my database open?  The DB is on our network
drive.

Thanks!

Author
15 Nov 2005 12:45 AM
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
Author
15 Nov 2005 11:04 PM
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/


Show quoteHide quote
"naiveprogrammer" <naiveprogram***@discussions.microsoft.com> wrote in
message news:59118F40-CC6E-49D4-9DC4-9EEBEC396496@microsoft.com...
> How can I tell what user has my database open?  The DB is on our network
> drive.
>
> Thanks!
Author
16 Nov 2005 8:47 AM
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

naiveprogrammer wrote:
Show quoteHide quote
>How can I tell what user has my database open?  The DB is on our network
>drive.
>
>Thanks!

Author
16 Nov 2005 9:41 AM
Keith W
"naiveprogrammer" <naiveprogram***@discussions.microsoft.com> wrote in
message news:59118F40-CC6E-49D4-9DC4-9EEBEC396496@microsoft.com...
> 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
Author
26 Nov 2005 7:39 AM
hilarywalker
I think you should look for a Networking administrator, he or she has more
knowledge about administration than the programmers like us.

Show quoteHide quote
"naiveprogrammer" <naiveprogram***@discussions.microsoft.com> wrote in
message news:59118F40-CC6E-49D4-9DC4-9EEBEC396496@microsoft.com...
> How can I tell what user has my database open?  The DB is on our network
> drive.
>
> Thanks!
Author
26 Nov 2005 9:22 PM
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