RE: Trying to link to Foxpro 2.0 database using Access 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: 04/05/04

  • Next message: Rush Strong: "Re: Cut and Paste"
    Date: Mon, 05 Apr 2004 21:51:10 GMT
    
    

    Hi viper53927

    Does anyone have those VFP open? If so, close them. Are you running any
    anti virus software? If so, disable it or prevent it from scanning VFP data
    files as shown here:

    321550 HOWTO: Optimize Visual FoxPro Applications While Using Norton
    AntiVirus
    http://support.microsoft.com/?id=321550

    Try creating a new folder and copying the table files into that folder.
    Can you see them with the ODBC driver now?

    I hope this helps.

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Sincerely,
    Microsoft FoxPro Technical Support
    Lee Mitchell

    *-- VFP8 HAS ARRIVED!! --*
    Read about all the new features of VFP8 here:
       http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
    Purchase VFP8 here:
       http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
     
    Keep an eye on the product lifecycle for Visual FoxPro here:
    http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
       - VFP5 Mainstream Support retires June 30th, 2003
       - VFP6 Mainstream Support retires Sep. 30th, 2003

    >Dear Message Board,

    >I have been working on this issue for about a month. I have an old program
    called "Track-It!" >which uses a FoxPro 2.0 database. I am was able to use
    Access 97 to link to the Database just >fine and create a link table. When
    I tried converting the database into Access 2000 format the >link table did
    not work anymore. I have done lots of research and found all of the
    different >Microsoft Articles. I have tried downloading the latest FoxPro
    ODBC driver and creating a new >DSN connection using the Free Table
    selection with the .dbf file. I then went into Access 2000 >and deleted the
    old link table and tried relinking the table using the ODBC database
    selection >with the ODBC DSN connection I just made. After I select the DSN
    connection, the next dialog >box is suppose to allow you to select the
    tables that you want to use in the database, but the >dialog box comes up
    completely empty. I have been trying many different times to get this link
    to >work. Any help would be greatly appreciated. You can either post a
    message in this thread or >you can e-mail me at viper53927@aol.com. Thanks
    for your time in advance.


  • Next message: Rush Strong: "Re: Cut and Paste"

    Relevant Pages

    • RE: Link Foxpro 2.0 database to Access 2000
      ... Try creating a new folder and copying the table files into that folder. ... Microsoft FoxPro Technical Support ... Access 97 to link to the Database just>fine and create a link table. ... ODBC driver and creating a new>DSN connection using the Free Table ...
      (microsoft.public.fox.helpwanted)
    • Re: Word mail merge with foxpro
      ... > I am trying to connect to a dbf fine not the database. ... >> I do not think you will be able to open a .dbc using ODBC by selecting ... >> using that approach (in the Select Data Source dialog, ... >>> Firstly the files of type drop down does not give a foxpro option. ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Access 2000 run-time error 80004005 - HELP
      ... try changing the column definition (make a backup of the ... > destination table is a linked table originating from a FoxPro v3 database. ... it appears MS is letting FoxPro die a slow death. ...
      (microsoft.public.fox.programmer.exchange)
    • Re: Process wont die when form is closed.
      ... The database is a Pervasive v.9 with an ODBC driver. ... The DataGridView works great except when I'm done and I click the X to close ... Or is the background thread just an automagic thing and I have to insert the IsBackground property somewhere in order for the code to shutdown properly? ... In this case it means that the code is stucked in the main thread, probably in the Pervasive ODBC driver. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Access 2000 run-time error 80004005 - HELP
      ... You could get the VFPOLEDB driver instead. ... I think Acess 2000 can use an OLE DB connection - it least programmatically. ... > destination table is a linked table originating from a FoxPro v3 database. ...
      (microsoft.public.fox.programmer.exchange)