T
Tracey
I have a series of macros that check for duplicates, delete duplicates, and
append records to a linked table in another database. I've tested the macros
on recordsets of 7,000 records and everything works fine. However, once we
started handling larger datasets (eg. 38,000 records) we began getting
problems. In the final append to the linked database the database thinks we
are appending 7,609,000 records. Invariably I get a "disk or network error"
message and all functionality stops. I have compacted and repaired the
databases, deleted the offending tables and rebuilt them, to no avail. Has
anyone had this problem and how do I fix it? Using Access 2003, Windows XP.
append records to a linked table in another database. I've tested the macros
on recordsets of 7,000 records and everything works fine. However, once we
started handling larger datasets (eg. 38,000 records) we began getting
problems. In the final append to the linked database the database thinks we
are appending 7,609,000 records. Invariably I get a "disk or network error"
message and all functionality stops. I have compacted and repaired the
databases, deleted the offending tables and rebuilt them, to no avail. Has
anyone had this problem and how do I fix it? Using Access 2003, Windows XP.