fox tables linked to msaccess

[Sinclair]

Hi,

I'm trying to create link of fox tables into msaccess from the source code.
I have installed vfpoledb, but there is only article how to link msaccess
table into msaccess. There is a part of code I understand:

Dim tblLink As ADOX.Table

tblLink.Properties("Jet OLEDB:Create Link") = True
tblLink.Properties("Jet OLEDB:Link Datasource") = strDBLinkFrom
tblLink.Properties("Jet OLEDB:Remote Table Name") = strLinkTbl

It is obvious that I have to replace "Jet OLEDB" with something like "VFP
OLEDB", but it does not work.
Is there solution?

regards from Sinclair

[Fred Taylor]

You might be able to get what you need from here:

www.connectionstrings.com

scroll down to the Visual FoxPro entries. There is info on ODBC and OLEDB.
--
Fred
Microsoft Visual FoxPro MVP

Post by Sinclair
Hi,
I'm trying to create link of fox tables into msaccess from the source code.
I have installed vfpoledb, but there is only article how to link msaccess
Dim tblLink As ADOX.Table
tblLink.Properties("Jet OLEDB:Create Link") = True
tblLink.Properties("Jet OLEDB:Link Datasource") = strDBLinkFrom
tblLink.Properties("Jet OLEDB:Remote Table Name") = strLinkTbl
It is obvious that I have to replace "Jet OLEDB" with something like "VFP
OLEDB", but it does not work.
Is there solution?
regards from Sinclair