Select a table in another password protected database?

Question

In Microsoft Access 2003 and Visual Basic 6, I am trying to copy a table to another password protected access database like this ...

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

Error with error: Invalid password

Does the Select INTO format not support the password using mdb, and should the password be in the connection string? If not, how do you refer to another row / connection database?

thank

Answer 1

What about:

SELECT * INTO Table2 IN '' [MS Access;PWD=TestPass;DATABASE=C:\Docs\database2.mdb]
FROM Table1

These days, I would be more likely to use something like the line below, it gives more control and allows for different ends:

SELECT * INTO Table2 FROM [MS Access;PWD=password;DATABASE=C:\Docs\database2.mdb].Table1

.

: http://www.connectionstrings.com/

Answer 2

,

SELECT * INTO [;PWD=TestPass;DATABASE=C:\Docs\database2.mdb].table2 FROM table1

""

SELECT * INTO [";PWD=TestPass;DATABASE=C:\Docs\database2.mdb"].table2 FROM table1

(Delphi SQL)