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

  • Thread starter Thread starter XR
  • Start date Start date
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!
 
got it.
"insert into _homework_cctv select * from
[F:\old\Work\bmcwork\data\xdata.bin;pwd=blahblah]._homework_cctv"
will work:)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessing Data on a password protected mdb from another mdb 1
Syncthing --- a continuous file synchronization program. 4
Open MS Acess with password protected in c# 3
Password Problem transferring old User files to new hd 4
Cannot open password protected Access DB 7
Legal use of .mdb files in a commercially distributed program 6
Password protect .mdb file 7
Password protected Access 2002: Preview/print report from VB6 3

Back
Top