|
-
Nov 18th, 2000, 03:08 AM
#1
Thread Starter
Lively Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|