How to Insert Rows to another DB File with PASSWORD

C

cheng_sh

Active member
Joined
Feb 18, 2003
Messages
25
Location
KL
I have an access database file with Table1 and would like to copy its rows to another database file with table TempTable1.

With the statement below, I can run it without any problem.

Insert Into TempTable1 (TempField1)
Select Field1 From Table1
In c:\database.mdb

BUT if I set a password for database.mdb, then error occurs

Not a valid password.

Anybody know how to solve it?
 
cheng_sh said:
BUT if I set a password for database.mdb, then error occurs

Not a valid password.
Click to expand...
My guess is that youre using the same connection and that it isnt valid if the other database is password protected.
Make a new connection to the other database and try to do the insert again.

HTH
/Kejpa
 
Back
Top