Make table query into password protected mdb

W

Walter Hofmann

Hi,

Acc2002:
When trying to run a query like

SELECT * INTO [thattable] IN 'C:\newDB.MDB'[;PWD=1234]
FROM [thistable];

I get an error 'Not a valid password'. This happens although I use the
query designer where I have to enter the correct password.

Any ideas?

Walter
 
G

Gary Walter

Hi Walter,

This works for me in Access 2000:

SELECT tbl1.* INTO
tblA
IN '' [MS Access;PWD=fred;DATABASE=C:\My Documents\test.mdb]
FROM tbl1;

that is 2 single quotes, not a double quote

Good luck,

Gary Walter
 
Top