Roni Sutton
Registered User.
- Local time
- Today, 02:19
- Joined
- Oct 18, 1999
- Messages
- 68
I am hitting an Access 97 db with a VB Executable that basically archives old data from a couple of tables which are linked. It pulls out records older than 10 days, copies them to another database, and then deletes them. It's fairly straight forward. This executable is started via a batch file at night after everyone has left for the day. Recently, when we come in the next morning and start to work, we receive "record is deleted" errors during every query attempt. When we look at the table, there are multiple records that say #DELETED in every column. Repairing the database takes care of this problem, but we've now had to repair it every morning for a week. I could really use some ideas on what could be causing this problem.
Thanks,
Roni
Thanks,
Roni