Create linked table in unsecured mdb with secured mdb.

[gsturtz]

I am currently running Microsoft Access 2000. I would like to create a
linked table in the .mdb file that is running my code with another
external .mdb file. The external file has been secured. The .mdb file
running the code is unsecured. I have the .mdw file used to secure the
external .mdb file. I also have a user ID and password in the secured
file.

I have been trying to create a tabledef in the current database but
can't find a way to refer to the other files system file. I would like
to use ODBC, but Access doesn't allow one .mdb file to use ODBC to
import data from another .mdb file.

I could use:

dim tdef as dao.tabledef
dim db as dao.database

set db = currentdb()
set tdef = db.CreateTableDef("tablename")
tdef.connect = ";DATABASE=databasefile.mdb;
db.Tabledefs.Append tdef

What is the connect string to provide the system file information?

 

[Simon Westenra]

I have the same situation.
I have an unsecured Access 97 database (source) with a table.
I have a secured Access 97 database (destination) with an equivalent table.
I want to export from the source the contents of a table and append them to
the destination table.
I've tried a query, but it won't take the MDW file as a parameter.
I've tried a macro, but it won't take the MDW file as a parameter.
I'm trying with DAO in code, but having lots of trouble with the
CreateWorkspace command as it says it's 'not a valid account name or
password'.
Any ideas?

Thanx in advance
Simon Westenra
HealthIntelligence
New Zealand