I need to link to another MDB table from an Access MDB.
This has to be done at runtime, so I think I have to
use 'Connect', but there is an error:
Runtime error 3170
Couldn't find installable ISAM
Code:
Set dbs = CurrentDb
strTable = "JetTable"
strConnect = "MDBpath"
strSourceTable = "tblTable"
Set tdfLinked = dbs.CreateTableDef(strTable)
tdfLinked.Connect = strConnect
tdfLinked.SourceTableName = strSourceTable
dbs.TableDefs.Append tdfLinked
It works when linking from the database window
so surely the above should be OK??
Any ideas
Cheers
