Re: VFP Driver Question

From: Cindy Winegarden (cindy_winegarden_at_msn.com)
Date: 12/02/04

  • Next message: Mark Smith: "Re: VFP Driver Question" 
    Date: Wed, 1 Dec 2004 22:26:23 -0500

    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: Mark Smith: "Re: VFP Driver Question"

    Relevant Pages

    • Re: VFP Driver Question
      ... To answer Josh's question, we are using ODBC. ... > The latest FoxPro and Visual FoxPro ODBC driver is downloadable from ... Does the refresh add data or also change existing ... > Are you picking up deleted records? ...
      (microsoft.public.fox.vfp.dbc)
    • Re: Access import off Fox Pro Tables
      ... Query analyzer using a linked server to the fox pro database, ... > Cindy Winegarden Microsoft Visual FoxPro MVP ... >> I am having an issue installing the visual fox pro driver. ... How can I get this VFP odbc driver? ...
      (microsoft.public.access.externaldata)
    • Re: Computer will not boot after installing SP2
      ... Found the screen refresh but it only shows "use hardware default settings" ... Not sure what you mean by "use your old graphics driver". ... Color 32bit defaultl refresh. ... This might mean that it won't let you change the refresh rate. ...
      (microsoft.public.windowsxp.help_and_support)
    • Re: Visual FoxPro ODBC Driver Installation & Configuration
      ... Do you see the Visual FoxPro driver listed in the Drivers tab of your ODBC ... > I've a piece of third-party software that requires the Visual FoxPro ODBC ...
      (microsoft.public.windowsxp.general)
    • Re: Access import off Fox Pro Tables
      ... Cindy Winegarden Microsoft Visual FoxPro MVP ... > I am having an issue installing the visual fox pro driver. ... > and try to install from the link you provided, I am getting the error "The ... How can I get this VFP odbc driver? ...
      (microsoft.public.access.externaldata)