Db getting corrupted

[kovas]

Sometimes when ppl just power off their pc without shutting down properly my access db gets corrupted, I usually just repair it and its fine after that. But until i repair it the app gives an error saying DB not recognized. Is there someway I can automate it in the error handler to repair it self without me doing it manually to avoid down time?

thank you.

 

[LazyMe]

You could perform a check on startup to see whether or not it needs to be repaired. I don't know what kind of data access you use. If you're using DAO you can use the RepairDatabase method. If you're using ADO it's also possible, but slightly diffrent. Check out this link for that:

http://www.developerfusion.com/show/123/

Greetings,
Rick