Locked Access application under Windows XP

J

Jane

We have an Access 2003 application loaded on our office workstations. The
application has a front end on the workstation and the back end on a server.
It is loaded on a folder on the c: drive (not a shared folder).

One workstation is used by several people. Each person has their own user
login on this machine. When one person is logged in and is using the
database, and another person jumps on the computer, logging in under their
own user account, they foul everything up by trying to open the database. We
get the message 'Database is locked' and the only way to solve the problem is
to log in as administrator and copy a fresh version of the database.

I don't like that people are doing this but it happens. Is there a setup or
configuration that I don't know about, or a way to prevent this from
happening?
 
C

Craig

It appears to me that when they log then don't bother to shut the database
down thus causing locking problems for the other person who is now logged on
and trying to use the db. Is this correct?
 
J

Jane

That was my first thought, but I tested different scenarios. I logged in as
one user, opened the database, closed the database, logged in as a different
user, and was locked out (I will test again today when I go into the office).
 
M

Margaret RM

Hello,

Did you get this issue resolved? I have a similar problem with multiple
users in Access 2003 not being able to open the database. I have had to
create a clean copy of the database many times as well.

If you have any information I would appreciate it.

Thanks, Margaret
 

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