Trying to compact a database - Help needed

[Guest]

Hi

Hopefully someone can help me.

I am trying to compact my database but the compact does not complete as it
says that me and another user are trying to change the data at the same time.
However, i am the only one using the database.

I have no idea why this is happening and how to resolve it!

Thanks in advance for your help.

Carol

 

[Guest]

Hello,
Try to open a new db and to import everything.
When it's done, compact the new db and if you still have the same problem,
come back here.
Phil,

 

[Nick Coe \(UK\)]

Assuming you are certain that there is no one else in the
database.

Use windows explorer to go to the directory/folder where
your .mdb file is located. Look for a file with the same
name as your application but with the suffix .ldb. If it
exists delete it. If it does not then you either have the
wrong folder or a corrupt database.

Have a look at Tony Toews site for info on dealing with
corruption.

http://www.granite.ab.ca/access/corruptmdbs.htm