B
Brian
I currently have a very simple database with a "Products"
table and a linked Foxpro table. Basically, the DB is
scheduled to run two queries once a day that deletes the
records in the Products table, then appends the values in
the Foxpro table back into the Products table using
criteria in a Yes/No field. Out of about 8000 or so
records, there are 10-20 that get appended with incorrect
data. The records that are appended incorrectly are
different every day and it is sometimes only certain
fields that are wrong (the primary key for the records
remains correct). I've tried a compact and repair, but it
did not fix the problem. Any ideas what might be causing
this?
table and a linked Foxpro table. Basically, the DB is
scheduled to run two queries once a day that deletes the
records in the Products table, then appends the values in
the Foxpro table back into the Products table using
criteria in a Yes/No field. Out of about 8000 or so
records, there are 10-20 that get appended with incorrect
data. The records that are appended incorrectly are
different every day and it is sometimes only certain
fields that are wrong (the primary key for the records
remains correct). I've tried a compact and repair, but it
did not fix the problem. Any ideas what might be causing
this?