Create Table Link in Access via Ado

G

Giumalex

I'm trying to create a table link in an Access application to a Interbase
database via ADO. I'm using a correct Oledb Driver for Interbase. The
problem is... , I'm trying to use these code...

-----------
'Create Link...
Set adoCat = New ADOX.Catalog
Set adoCat.ActiveConnection = adoCn

Set adoTbl.ParentCatalog = adoCat
adoTbl.Name = "LinkTable"
.....
adoTbl.Properties("SIB:Create Link") = True
adoTbl.Properties("SIB:Remote Table Name") = "LinkDatabaseTable"
.....
'Append the table to the tables collection
adoCat.Tables.Append adoTbl

Form1.Caption = "Link Created..."
---------

but "adoTbl.Properties("SIB:Create Link") = True" is not recognized on my
SIBprovider...

how can I link the table whit OleDb?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Linked Table to AS/400 6
ADO Error Attempting to Link Table 1
Adding table into existing access database via ADO 0
Creating a table link via ODBC in another ACCESS database 1
How to create a Linked (text) table in xl vba to a .mdb 0
Error 3251 using ADO & VBA to drop a table! 9
How to, using Excel VBA, link a text file to a .mdb file? 0
Access linked table to text file with schema.ini not working ADO 3

Top