Who is using the database?

R

RC

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
 
K

Keith Wilby

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

Google for "LDBVIEW.exe".

Regards,
Keith.
www.keithwilby.com
 
W

Willem

Look on the server for the file Console.msc Open it and you will be able to
identify the user.

Willem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top