Can you see who is currently using your database?

[Heather]

Hello,

Is there a way when a DB is in use to see who is in it? I am using MS 2003.

Thank you

 

[Dirk Goldgar]

Hello,

Is there a way when a DB is in use to see who is in it? I am using MS
2003.

This web page shows several ways to do it:

http://www.mvps.org/access/general/gen0034.htm

 

[aaron.kempf]

SQL Server profiler has this functionality built in.

or-- you can just run SP_WHO to see who has a SQL Server database
open.

it's amazing to me that you guys think that Jet is useful.
It's not because it doesn't have 1/4 of the functionality of SQL
Server.

Jet is HARDER to use and MORE EXPENSIVE TO IMPLEMENT.

 

[Tony Toews [MVP]]

Is there a way when a DB is in use to see who is in it? I am using MS 2003.

Please ignore Aaron's posting as Aaron's answer to just about every
question is SQL Server and ADPs. No matter how appropriate his
response.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/