RE: Trying to link to Foxpro 2.0 database using Access 2000
From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: 04/05/04
- Previous message: Igor Korolyov: "Re: Clarify EngineBehavior"
- In reply to: Viper53927: "Trying to link to Foxpro 2.0 database using Access 2000"
- Messages sorted by: [ date ] [ thread ]
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.
- Previous message: Igor Korolyov: "Re: Clarify EngineBehavior"
- In reply to: Viper53927: "Trying to link to Foxpro 2.0 database using Access 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|