Sporadic db corruption

J

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
 
J

John

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

Thanks

Regards
 
J

John

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

Thanks

Regards
 
T

Tony Toews [MVP]

John said:
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
 

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

Similar Threads


Top