Dealing with Access object corruption...

[Kenny-Z]

Hi group,

at least on my setup (Access2K/Win98SE), I've noticed a tendency for
Access objects to become corrupt, mainly forms and/or their associated
VB modules... Typical error messages that occur when trying to run a
form or view its code are along the lines of "You canceled the
previous operation... (no I didn't), or "Error accessing file. Network
connection lost..." (what network?). Obviously these useless error
messages are resulting from some unexpected situation (file
corruption?). Also, errors may fly referring to a form that has been
deleted from the Database window. Decompiling and repairing the file
never seems to help; only frequent backups can save the day-or at
least part of it. But then you need to identify all of the corrupted
objects and transfer only the good objects to a new container (mdb).
Good times.

But that's the problem-it seems I've had to get into the habit of
saving a backup of the original file before nearly every change made
to a form. You may later discover your backup has ended up with
corrupted objects! Multiple, frequent backups it is.


I'm wondering if other developers have had the same problems and if
there are any general recommendations on how to minimize corrupting
mdb files.

thanks for reading,

kz

 

[Bruce M. Thompson]

Funny you should ask. See the following page at Tony Toews' web site:

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm

This page represents an extraordinary effort on his part to compile useful
resources dealing with this common problem. See also:

Best Practices for Microsoft Access
http://www.granite.ab.ca/access/bestpractices.htm

 

[Kenny-Z]

Helpful. Thanks Bruce.

kz

Funny you should ask. See the following page at Tony Toews' web site:

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm

This page represents an extraordinary effort on his part to compile useful
resources dealing with this common problem. See also:

Best Practices for Microsoft Access
http://www.granite.ab.ca/access/bestpractices.htm