F
Francisco R
I have two password-protected databases (Access 2000).
Both have the same password. I'm creating a query to copy
some data from one database to the other one. I use this:
INSERT INTO Table1 IN 'c:\mydb1.mdb' SELECT Field1, Field2
FROM Table2 WHERE Field1=anynumberhere
Table1 already exists so thats why I use INSERT INTO but I
received an 'Invalid Password' message when I run the
query...why it could be happening? Something I noticed is
that sometimes it works when the source (Table2) has data
and it fails when it doesn't.....
Is there a way to specify the password within the query?
Any help would be very appreciated...I'm stuck on this.
Regards.
Both have the same password. I'm creating a query to copy
some data from one database to the other one. I use this:
INSERT INTO Table1 IN 'c:\mydb1.mdb' SELECT Field1, Field2
FROM Table2 WHERE Field1=anynumberhere
Table1 already exists so thats why I use INSERT INTO but I
received an 'Invalid Password' message when I run the
query...why it could be happening? Something I noticed is
that sometimes it works when the source (Table2) has data
and it fails when it doesn't.....
Is there a way to specify the password within the query?
Any help would be very appreciated...I'm stuck on this.
Regards.