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?
 
Top