Track Repair and Corruption

[AccessAce]

Help. I'm working with an Access2000 database that gets corrupted frequently. Users from all over the network, which is TCP/IP only, use the database on a regular basis. I have implemented some code to track who goes in and out and when, but since several of the users know how to repair the database, I would like to programatically track how often the database gets repaired, and if possible, who initiated the fix. Any ideas?

 

[zevw]

I have had this problem for months and we have a network with a few hundred employees. I found that most of the corruption happens when the program bombs out due to some code issue, and it took a few months to finally get through all the bugs. I do not let the user repair the database, so that I know immediately when they bomb out and they let me know.

I keep the data and interfaces(forms) in to seperate databases and the interface DB is linked to the DB with the data. and I locked the database so that the dont have the menu to repair.

But now Thank G-D for the last 6 months the database was not corrupt and did not need to be repaired in middle of the day. I also scheduled an automatic process for
11 PM each night to compact and repair the Databases for the next day. On each machine the Databases close with an On Timer event procedure each night at 9 PM.

I hope this helps you somewhat.