Link MSA2003 to VisualFoxPro

[Jack Hudson]

MSDN Access help says docmd.transferdatabase can use ado to link to nonodbc
files using the ActiveConnection property of the Recordset Object. Trying
to link VFP free-file(s). Can successfully fetch records using
ADO.Connection and ADO.Recordset and Get(), and get a 'connection string'
from .ActiveConnection. But using that string in the DoCmd.TransferDatabase
method just gives error(s).

Anyone have any success linking 'new' VFP files to MSAccess2003, either with
docmd or some other coding method?

Thanks. Jack