Make table query into password protected mdb

  • Thread starter Thread starter Walter Hofmann
  • Start date Start date
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
 
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
 
Back
Top