Compact Problem Revisited

  • Thread starter Thread starter Chuck Santo
  • Start date Start date
C

Chuck Santo

I have a access97 mdb that will not allow me to compact. It tells me
that two users are tying to update the same data. I have gotten
everyone out and searched for lock files and have found none.

One user can get in the program very quickly (I would imagine this is
one of the users that the program thinks is updating a record)
another user can get in but it takes a minute or two for the program
to load up. Another user gets a file in use error when they try to
open the program.
Click to expand...

I have opened the Access97 mdb in exclusive mode but when I try to compact I
still get the error that 2 users are trying to update the same data.

I have searched every computer (3) on the network for ldb files and have
found none.

Any way to find out what record the system thinks is being edited by 2
different people at the sam time?

TIA
 
First, your database needs to be split with only the data on the server and
each workstation having a copy of the front-end with all the code, etc.
linked to the data tables. The kind of error you are seeing often happens
when everyone is sharing the same front-end code, and is a major source of
database corruption.

Make a copy of the database as a backup. Kick everyone out of the database
file from the server, then compact the database. If that doesn't work,
reboot the server and compact the database.

Make another copy of your compacted database since you will probably be
needing it soon if you don't have your database split.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin,
Thank u 4 ur response.

The database is split. Each user has a copy of the front end on their local
machine which is linked to the tables that are in the corrupted mdb.

I took you advise and restarted the server and it appears that this fixed
the problem. I was able to see what table in the mdb was giving my the
problem with the syscompaterror table that was generated.

Thanks again
 
Back
Top