VFP Driver Question

[Mark Smith]

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.

[Josh Assing]

are you using odbc?

Post by Mark Smith
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.

---
Remove x's to send.

[Cindy Winegarden]

Hi Mark,

The latest FoxPro and Visual FoxPro ODBC driver is downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.

You haven't said anything about the process by which the Access database
table is refreshed. Does the refresh add data or also change existing
records? Are you absolutely sure there are no duplicate records, including
deleted records?

Are you picking up deleted records? There is a setting in the Fox ODBC
driver where checking the Deleted box corresponds to Set Deleted On which
causes deleted records to be ignored. Since this setting is in the ODBC
setup it will vary from one machine to another as you describe.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP

Post by Mark Smith
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.

[Mark Smith]

Hi. To answer Josh's question, we are using ODBC. The way our refresh
works, is we run an Access script which deletes all data in our MS Access
table, and then selects all records from the dbf file into a recordset and
inserts them into the Access table. It's a very simple process, but for
some reason some of the records in our production process get their data
mixed in with records of others...but is fine in our development
environment. It is very inconsistent, meaning it doesn't happen to the same
records every time, and sometimes it doesn't happen at all. In each
environment, the deleted check box is checked. Thanks a lot.

Post by Cindy Winegarden
Hi Mark,
The latest FoxPro and Visual FoxPro ODBC driver is downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.
You haven't said anything about the process by which the Access database
table is refreshed. Does the refresh add data or also change existing
records? Are you absolutely sure there are no duplicate records, including
deleted records?
Are you picking up deleted records? There is a setting in the Fox ODBC
driver where checking the Deleted box corresponds to Set Deleted On which
causes deleted records to be ignored. Since this setting is in the ODBC
setup it will vary from one machine to another as you describe.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP

Post by Mark Smith
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.