views:

55

answers:

1

In Microsoft Access 2003 and Visual Basic 6 I'm trying to copy a table to another access database that is password protected like this...

Select * INTO table2 IN 'database2.mdb' [;Password=TestPass] From table1

It fails with "Not a valid password"

Does the Select INTO format not accept the password with the mdb, and the password has to be in a connection string? If not, how do you reference a different connection string/database?

thanks

A: 

How about:

SELECT * INTO Table2 IN '' [MS Access;PWD=TestPass;DATABASE=C:\Docs\database2.mdb]
FROM Table1
Remou
You mean: `SELECT * INTO [;PWD=TestPass;DATABASE=C:\Docs\database2.mdb].table2 FROM table1`?
Michel de Ruiter
oops, updated answer.
Remou
can't get either of these 2 to work. I'll try and follow up with more info... thanks
Brian
I tested the SQL above in the query design window of Access.
Remou