
Run-time error '3011' linking table
Hi -
I'm trying to link an Access table in code and get run-time error 3011:
The code is as follows:
Set td = db.CreateTableDef("LinkedTableName")
td.Connect = ";Q:\Source\Exxon\CorpOffice\AIS\Test.mdb"
td.SourceTableName = "WRK_1339244"
db.TableDefs.Append td
...on that last line I get error 3011: The Microsoft Jet Database Engine
could not find the object "WRK_1339244". Make sure the object exists and
the name and path name are spelled correctly.
Everything is correct (DB/path name, table name, and it exists).
Any suggestions?