Access 2007 mdb Deletes Self on Compact

B

bigmike2001

I am perplexed. I have a 2007 mdb which twice now has deleted itself
on compact. I understand the db creates a copy of itself when
compacting by creating something like db1.mdb then renaming it to the
source db when compact is complets.
Twice while compacting an error was produced which user cannot recall
and when said-and-done the original and db1 are GONE (thank goodness
for backups). Has any one ever experienced this before.
The mdb resides on a server and has multipule uers. DB is not split
(as it should be).

Any ideas are apprecuiated.
 
A

a a r o n . k e m p f

Perhaps, if Jet is too complex-- maybe you should move to a platform
that 'just works'-- like SQL Server for example
Perhaps, if Jet is too complex-- maybe you should move to a platform
that 'just works'-- like SQL Server for example
Perhaps, if Jet is too complex-- maybe you should move to a platform
that 'just works'-- like SQL Server for example
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top