How to test that a database has no corruptions.

[Abacus1234]

Is there anyway, other than Repair and Compact to be sure that a database going into production has no corruptions?

[ranman256]

Dont think so.

[ItsMe]

One thing that I do on a consistent basis is to compile my code. Also, when I am done designing and building a DB, I will import the objects to a new DB. I will, sometimes, do the same thing for forms and reports. For instance, if a form is very complex, I will create a new form and copy over the controls from the original form. Then, I will create new Sub Procedures and copy over the VBA.

As I build a DB I will do various combinations of all these techniques, including Compact and Repair.

[Abacus1234]

Thanks, I appreciate all the ideas.