Hi,
Please hlep me, I am really confused. I have created a number of queries and am exporting the results as new tables in another database (DB1.mdb). This database is password protected. I am also running append queries to add the newly exported information, to existing tables in the password protected database. This all works fine.
My confusion starts now!! I am trying to export the results of another query as a new table in an entirely different database (DB2.mdb), which is also password protected. I keep getting an error "Not a valid password".
Does anyone know why? Am I limited to the number of protected databased I can export information to?? What am I doing wrong??
Cheers
SID
Please hlep me, I am really confused. I have created a number of queries and am exporting the results as new tables in another database (DB1.mdb). This database is password protected. I am also running append queries to add the newly exported information, to existing tables in the password protected database. This all works fine.
My confusion starts now!! I am trying to export the results of another query as a new table in an entirely different database (DB2.mdb), which is also password protected. I keep getting an error "Not a valid password".
Does anyone know why? Am I limited to the number of protected databased I can export information to?? What am I doing wrong??
Cheers
SID