Access DB keeps getting "repair message"

[Brad]

There is an Access DB for logging bugs where I work. Many people use it at
the same time. Sometimes, however, it will lock you out and say it needs to
be repaired. I know that when you actually go into the database for
creating tables and designs that you need exclusive access to it, but this
happens after I or another user exited out of the "development" part of the
program.

It will say that it needs to be repaired and someone has it locked out
exclusively. Even after the computer exits the program it won't let anyone
in. Sometimes it will say that the user has it open exclusively and it will
give the machine number, but regardless of what computer is used, it will
always give that persons machine number (whoever is trying to open it)
saying that they have it open exclusively even though they really don't.

Does anyone have an idea about why this is happening? Also how can this be
repaired? Choosing "Compact and repair" usually doesn't work.


Thanks,
Brad

 

[John Vinson]

Does anyone have an idea about why this is happening? Also how can this be
repaired? Choosing "Compact and repair" usually doesn't work.

It sounds like you're all using the same single database. This is a
BAD corruption risk: I'd strongly suggest splitting the database
(Tools... Database Utilities... Database Splitter Wizard) into a
shared "backend" with the tables, and a "frontend" with the forms and
queries and reports; each user should have their own copy of the
frontend.

See http://www.granite.ab.ca/access/corruptmdbs.htm for some pointers
on preventing and (sometimes) curing corruption.

John W. Vinson[MVP]