Sporadic db corruption

[John]

Hi

Occasionally I get problem with one of the forms in an access 97 db when it
can not be compiled or turned into MDE with error that access can not read
data from form 'xxxx'. It gets repaired sometimes with a database repair.
Sometimes a decompile helps. But the problem is not permanently fixed
despite doing decompile and importing into a new db several times.

What can I do to fix this please?

Thanks

Regards

 

[John]

PS: The problem is relatively new, this access 97 app is over 10 years old
with no such problem.

Thanks

Regards

 

[John]

PS: The problem is relatively new, this access 97 app is over 10 years old
with no such problem until now.

Thanks

Regards

 

[Tony Toews [MVP]]

Occasionally I get problem with one of the forms in an access 97 db when it
can not be compiled or turned into MDE with error that access can not read
data from form 'xxxx'. It gets repaired sometimes with a database repair.
Sometimes a decompile helps. But the problem is not permanently fixed
despite doing decompile and importing into a new db several times.

Saving the form under a new name isn't sufficient to clear this kind
of corruption in A2003. So what I do is click on the object name in
the database container window, Ctrl+C to copy and Ctrl+V to paste the
form. I'm then prompted for a new name.

Alternatively try importing all the objects into a new MDB. If you
have a lot of objects minimize the database container window as
otherwise Access will waste a lot of time refreshing the window.

Note that compacting an MDB/ACCDB will only clean up tables and
indexes. It is not designed to cleanup other objects which have
corruption.

Tony