Error When Attempting to Compact and Reapir

[JamesJ]

access 2007 sp2

I posted a question concerning this and found no solution but I have found an article.
Apparently no one was aware of this article when I posted this before:

http://blogs.msdn.com/b/access/arch...r-might-delete-your-database-access-2007.aspx

I still get this error periodically.
Problem is I've been told preventing db corruption is to Compact and Repair, Compact and Repair and Compact and Repair.
Doesn't do me much good if this error continues to happen.

Is there as fix??

Jamnes

 

[Jeanette Cunningham]

James,
Have you had a look at the suggestions for preventing corruption.
There are some things you may be doing that are causing your database to
corrupt more often.
Have a look at this:
http://allenbrowne.com/ser-25.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


access 2007 sp2

I posted a question concerning this and found no solution but I have found
an article.
Apparently no one was aware of this article when I posted this before:

http://blogs.msdn.com/b/access/arch...r-might-delete-your-database-access-2007.aspx

I still get this error periodically.
Problem is I've been told preventing db corruption is to Compact and Repair,
Compact and Repair and Compact and Repair.
Doesn't do me much good if this error continues to happen.

Is there as fix??

Jamnes

 

[JamesJ]

So, what you're saying is this error occurs because of a corrupted
database??

James

 

[Jeanette Cunningham]

Yes, I haven't heard of it happening with a database that isn't corrupted.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[JamesJ]

So far it seems I'm following the rules as to preventing db corruption.
Several other articles I have read about this issue says nothing about db
corruption, only a bug in access.
Do a searches the web for "KB article 950812: Compact and repair
might delete your database (Access 2007)" you will find many unhappy returns
for this error. Some even had their db's deleted.

Good thing I back the db up 3 times a day, I'd be screwed.

James

 

[Jeanette Cunningham]

Some bug. I hope the hotfix solves it for you.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tony Toews]

Problem is I've been told preventing db corruption is to Compact and Repair, Compact and Repair and Compact and Repair.

Not really. Well a compact and repair will fix things and is a good
thing to do monthly or so. But most corruption causes aren't solved
by compacting.

Doesn't do me much good if this error continues to happen.

Is there as fix??

See the corruption causes page at the Microsoft Access Corruption FAQ
at http://www.granite.ab.ca/access/corruptmdbs.htm

Tony

 

[David W. Fenton]

most corruption causes aren't solved
by compacting.

I would amend that:

Most reported "corruption" is not corruption of anything other than
the flags in the header of the files, usually because they didn't
get appropriately written for some reason or another. Very rarely
does a file ever get actually corrupted, and in those cases, the
data are often recoverable (though it depends on the type and extent
of the corruption).

 

[Tony Toews]

I would amend that:

Most reported "corruption" is not corruption of anything other than
the flags in the header of the files, usually because they didn't
get appropriately written for some reason or another. Very rarely
does a file ever get actually corrupted, and in those cases, the
data are often recoverable (though it depends on the type and extent
of the corruption).

Hmm, my reply was poorly worded. I'll try again.

Tony

 

[Tony Toews]

Problem is I've been told preventing db corruption is to Compact and Repair, Compact and Repair and Compact and Repair.

Running compact and repair on a regular basis won't solve the
underlying cause of many corruptions. They're usually caused by
problems outside of Jet such as intermittetntly flaky network
hardware, bad network card drivers, etc, etc.

That said running compact and repair on a regular, say monthly basis,
is a good idea.

See the corruption causes link at my web page mentioned in my prevoius
posting.

Tony