compacting problems

[teiben]

I have a database that will not compact (using 97) the error message I get is the microsoft jet engine stopped the process because you and another user are attempting to change the data at the same time.

I copied this database on my desk top, and absolutely no one is using it.
I can 'repair" it, but not compact it.

 

[ghudson]

Make a copy of it first, just incase.

Import all of the db objects into a new db. Your old db has a slight corruption problem that will only get worse until nobody can open it.

 

[Rich]

Make sure you don't have a rogue LDB lurking around somewhere

 

[teiben]

what is rogue LD?

 

[ghudson]

The record locking file that Access creates when a database.mdb file is opened. .ldb file contains the user info that has your db opened. You can open the .ldb file with notepad to see what is in it. If you can delete the .ldb file that means nobody's computer has a lock on the mdb file.