>MDB2DBC and automation require Access. I don’t have Access installed on my system and I don’t think my client does either. Sorry to sound like such a newbie, but how would I do it using your 2nd and 3rd recommendations:
>OleDB and ADO
>ODBC and SPT or Views

Paul:

There's no problem with asking questions < g >


You can create a DSN with an ODBC connection string
(you can get them at http://www.connectionstrings.com/ for example)

"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"

Or you can use a DSNLess connection.
See:
http://fox.wikis.com/wc.dll?Wiki~ProgrammaticallyCreatingDSNs
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect

You can then use SQL PassThrough (SPT) to run a query (or use a Remote View)
http://fox.wikis.com/wc.dll?Wiki~SQLPass-Through
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgusing_sql_pass_through_technology.asp

Or you can use a CursorAdaptor (VFP80)


Or you can use a connection to an OleDB Provider:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"

For examples on using ADO see:
http://fox.wikis.com/wc.dll?Wiki~CategoryADO
http://fox.wikis.com/wc.dll?Wiki~ADOJumpStart
http://fox.wikis.com/wc.dll?Wiki~ADORecordSets
http://fox.wikis.com/wc.dll?Wiki~UsingADO

HTH