How do I copy whole content of a table to another table with password?

"carlo_um" <[email protected]> Wed, 20 Aug 2003 13:27:35 -0000
Newsgroups gmane.comp.lang.delphi.programming
Message-ID <[email protected]>
The code below works if I don't place a password security on the 
Access Database. But if I place a password on the access database, an 
error message will appear when I execute the code that the password 
is incorrect.

How do I specify the password if the destination or source database 
has a password?

qry.active := false;
qry.sql.clear;
qry.sql.add('Insert into [c::\mydestination\gasdestination.mdb].
[branch] Select * from [c::\mysource\gassource.mdb].[branch]');
qry.execsql;



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->

Delphi VCL Top Sites!
http://www.sandbrooksoftware.com/TS/TS2/Components.shtml
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/