ODBC Problem

[marksmithy69]

I have a simple MS Access database table which is refreshed every week with data from a dbf file using Visual Fox Pro driver version 6.01.8630.01. The table has an id column, first name, last name and ssn. The problem is, sometimes after the refresh has finished, some of the records will have data from another record. For example, John Doe will have Jane Doe's id and Billy Bob will have Johnny Doe's SSN. This only happens to a couple of records...maybe 2 or 3 out of 40,000 total records.

However in our development environment, which has the exact same database, accessing the same dbf file, but using Visual Fox Pro driver version 6.00.8440.00, it works perfectly. Both environments use Windows NT. Is there an issue with this particular driver version? Thank you.

 

[Blorf]

When you make the connection, are you including indexes? If so, try dropping them and see if the confusion goes a way. May be slower, but might work.


ChaZ