Who is using the database?

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

Guest

I have a database on a shared server and users have an entry window to that
database on their own PC. It enables users to create their own queries etc
without cluttering up the server where just the raw data is stored.
Problem - I want to change the design of the table on the server and to do
that all users have to be out of the application. If one user is using the
application, when I try to use design mode on a table I get an error message
saying someone else is using the table.
Is there a way that I can identify that particular user.
I am using access 2000
 
RC said:
I have a database on a shared server and users have an entry window to that
database on their own PC. It enables users to create their own queries etc
without cluttering up the server where just the raw data is stored.
Problem - I want to change the design of the table on the server and to do
that all users have to be out of the application. If one user is using the
application, when I try to use design mode on a table I get an error
message
saying someone else is using the table.
Is there a way that I can identify that particular user.
I am using access 2000
Click to expand...

Google for "LDBVIEW.exe".

Regards,
Keith.
www.keithwilby.com
 
Look on the server for the file Console.msc Open it and you will be able to
identify the user.

Willem
 
Back
Top