|
Home > Archive > FoxPro database connector > September 2005 > fox tables linked to msaccess
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
fox tables linked to msaccess
|
|
| Sinclair 2005-09-21, 7:24 am |
| 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 2005-09-21, 11:25 am |
| 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
"Sinclair" < Sinclair@discussions
.microsoft.com> wrote in message
news:5C8429EE-7DC4-4B07-9243- 7AF8B8B9EAAA@microso
ft.com...
> 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
|
|
|
|
|