How do you open a Foxpro *.dbf database file using ADO.
Simple open please.
VBKNIGHT
Oct 27th, 2000, 04:47 AM
use ODBC?
bar
Oct 27th, 2000, 07:16 AM
Here's the connection string that you use.
ADOConnectionObject.ConnectionString = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=<path>;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
The <path> tag refers to the folder where the .dbf file is and not the filename of the .dbf file. When opening the recordset object use the .dbf's name.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.