Linking Tables, ADOX 2.1

Linking Tables, ADOX 2.1

Post by patte.. » Tue, 26 Oct 1999 04:00:00

I can link it up just fine and read from the table, but I cant update
the linked table. Any Ideas what I am doing wrong?  With dao it worked
just fine by creating a new tabledef, datasource, appending. Thanks!

    Set tbl = New ADOX.Table

    tbl.Name = mvarImpTbl
    Set tbl.ParentCatalog = catDB
    tbl.Properties("Jet OLEDB:Create Link") = True
    tbl.Properties("Jet OLEDB:Link Datasource") = mvarImpPath
    tbl.Properties("Jet OLEDB:Link Provider String") = "dBase III;"
    tbl.Properties("Jet OLEDB:Remote Table Name") = mvarImpTbl

    catDB.Tables.Append tbl
    Set tbl = Nothing

Sent via
Before you buy.


1. MDAC 2.1 and linked tables from access 2.0 in access97.mdb failed

After Install of mdac 2.1 (shipped with ms sql 7.0) I can't access
linked tables from access 2.0 in my access97 database.
I cant downgrade to mdac < 2.1, because I need the newest ODBC-Drivers
for MS SQL 7.0 for uniqueidentifier fields.

Any Idea?
Thanks for help.

Thomas Hatt

2. HELP - 'IO Error'

3. Using ADO 2.1 / ADOX / ADO 2.0 with C++

4. newbie question re:arrays of unknown size

5. MDAC version problems continue to haunt me

6. Cteate a datebase with ADOX version 2.1

7. Converting SQL6.5 to SQL2000

8. ADOX 2.1

9. ADOX Linking external tables in VB

10. ADOX and Linked Tables

11. ADOX & Linked table