Append query failure if password used

P

PharmTouch

I’m unable to get an append query to run properly when the target database
(in this case PTData1.mdb) is passworded. It runs fine with the code below if
there is no password.

SQLcode

INSERT INTO xxyyy ( ID, Catz, Dogz ) IN 'C:\PharmTouch\PTData1.mdb'
SELECT xxixx.ID, xxixx.Catz, xxixx.Dogz
FROM xxixx;

If there is a password (frog) on the target, then the system returns “not a
valid passwordâ€

SQLcode

INSERT INTO [;PWD=frog].xxyyy ( ID, Catz, Dogz ) IN
'C:\PharmTouch\PTData1.mdb'[;PWD=frog]
SELECT xxixx.ID, xxixx.Catz, xxixx.Dogz
FROM xxixx;


Any ideas about what I’m doing wrong?


Thanks

PharmTouch
 
D

Douglas J. Steele

You definitely do not need to put the password twice. See whether this
works:

INSERT INTO xxyyy ( ID, Catz, Dogz ) IN
"C:\PharmTouch\PTData1.mdb" ";PWD=frog"
SELECT xxixx.ID, xxixx.Catz, xxixx.Dogz
FROM xxixx;

If it doesn't, try creating a linked table so that you don't need the IN
clause.
 
Top