Database Corruption

[MidNite]

I recently got some unusual error messages like "the search key was not found" when clicking on a record and also error messages saying "the record could not be saved."



Googling the message revealed that it was probably database corruption. I recently had a power outage which is known to cause database corruption.

On a hunch I thought that the it might be a particular table.

I imported all the objects into a fresh Access Database except for the suspect table.
Then I copy the text from the suspect table to a new table.

The problem seems to be solved.

My question is: Does Access database corruption occur primarily in tables and is replacing a table a good strategy to fix Access database corruption?

Thank You

[isladogs]

There are two possible types of corruption in an Access application
1. Corruption of data in one or more records in a table. Your approach is valid for that situation
2. Corruption of compilation code in the VBA project. Decompiling the project is required to fix that. Its quick and easy.

However, if either type of corruption gets beyond a certain point, the application may be irreversibly damaged and you will be unable to open it or recover its contents.
Hence the need to make regular backups, during development and once in production.

[MidNite]

Thank you for your comments. Regards

[isladogs]

You're welcome and also welcome to the forum