Hi All,
I am trying to append some data from one database to another using an append query. The database I would like to append to has a password and I keep getting a "Not a valid password" error when I run the query. This is what my file name looks like in the append file name box: g:\...\perfmeasdaily.mdb ";PWD=goodjob". The password automatically inserted when I set up the query. I thought that I should be prompted to enter a password. What am I doing wrong?
Thank you for you help.
I am trying to append some data from one database to another using an append query. The database I would like to append to has a password and I keep getting a "Not a valid password" error when I run the query. This is what my file name looks like in the append file name box: g:\...\perfmeasdaily.mdb ";PWD=goodjob". The password automatically inserted when I set up the query. I thought that I should be prompted to enter a password. What am I doing wrong?
Thank you for you help.