Re: VFP Driver Question
From: Mark Smith (marksmit_at_nortelnetworks.com)
Date: 12/02/04
- Next message: Wilson Thomas: "long file name"
- Previous message: Cindy Winegarden: "Re: VFP Driver Question"
- In reply to: Cindy Winegarden: "Re: VFP Driver Question"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Dec 2004 09:33:20 -0500
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.
"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:Oz0YSAC2EHA.804@TK2MSFTNGP12.phx.gbl...
> 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
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "Mark Smith" <marksmit@nortelnetworks.com> wrote in message
> news:coleem$3sb$1@zcars0v6.ca.nortel.com...
> >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.
> >
> >
>
>
- Next message: Wilson Thomas: "long file name"
- Previous message: Cindy Winegarden: "Re: VFP Driver Question"
- In reply to: Cindy Winegarden: "Re: VFP Driver Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
