How to transfer data between two independent but password protected mdb files?

X

XR

For example, I intend to execute such a sql statement:
"insert into _homework_cctv select * from
[F:\old\Work\bmcwork\data\xdata.bin]._homework_cctv"
but F:\old\Work\bmcwork\data\xdata.bin is protected by a password. Access
always tells me the password is wrong.
How can I tell access the password of the later database?
thx!
 
X

XR

got it.
"insert into _homework_cctv select * from
[F:\old\Work\bmcwork\data\xdata.bin;pwd=blahblah]._homework_cctv"
will work:)))
 
Top