Handling back end "compact on close" failure

[RzB]

I have a single user application that is a split front
end/back end design.The front end is an MDE.
The back end is an MDB, no code, forms
etc just tables.

I have "Compact on Close" set on the backend.
However, just occasionally it seems that the compact fails.
It throws a message like...

"Can't open xxx.mdb, possibly corrupt.. etc"

can't remember the exact words...

I have two questions..

1. Where do I trap this error... In the "on error" of the main
front end form?

2. How can I force this error - so that I can test any
error handling code that I add.

Thanks,
Roy

 

[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

 

[RzB]

Ooops... - have reposted as new post..
Apols..
Roy..