Unanswered: how to create linked table in access with VBA code
I use access2000 and SQL 2000. There are one database testDB, and DSN testDB. I want to create a linked table in access 2000 to link the table in testDB with windows authentication
Here is what I did:
' Create the table def.
Set tdf = db.CreateTableDef("dbo_table1")
' Connect the table
tdf.Connect = "DSN=testDB;DATABASE=testDB”
' Set the source table name
tdf.SourceTableName = "dbo.table1"
' Add the table def to the tabledefs collection
' refresh the link
But I failed to create linked table. I check what’s wrong, I find the step tablDefs.append got the error 3170
Anybody have some idea what’s wrong? Or how to create the linked table.
By the way, if the table exist, I relink to other databse, it’s no problem.