Can a db be intermittantly corrupt?

R

RzB

Using Access 2002 and Win XP

I have a database that is the backend of a split frontend / backend design.

It consists of Tables only. No code, macros, forms reports. Just tables.

I have compact on close enabled.

If I open the db and then close it, I will intermittantly get an error...

the error is a 3049

http://pix.gillandroy.com/Mapl/CompactError.jpg

and the compact does not work... If I don't get the error the
compact works just fine...

Can a db be intermittantly corrupt?

Any thoughts?
Thanks,
Roy
 
Top