>Hi all,
> I am new with ADO, which version of MDAC should I download to work with VFP5.0 DBC/DBF , Access 2000 databases and MSDE ?
>Can somebody give me an example of how to work with Access 2000 databases using
>ADO either connection string or dsn ?
>
>Thanks a lot.
>
>Kam
Download MDAC 2.5, since 2.6 does not have the VFP ODBC driver.
An simple MDB connection string sample follows:
lcMDBStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myDir\myAccess.mdb;"
oCn = Create("ADODB.Connection")
oCn.Open(lcMDBStr)
oRS = oCn.Execute("Select * From myTable")
For sample connection strings VFP, SQL Server & Access get from the UT downloads the following file: "ADOGetRows.jcRStoCursor". See testmyrs.prg once you downloaded it.