How to Insert Rows to another DB File with PASSWORD

[cheng_sh]

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?

[kejpa]

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

 

Not a valid password.

My guess is that you're using the same connection and that it isn't 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