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

Hi,
 
You can use Session.Addpassword(thepassword)
before open query. Both of the tables has got different password you must use session.addpassword for each password.
 
Zekeriye Bozkurt;

carlo_um <[email protected]> wrote:
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
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 the Yahoo! Terms of Service. 


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

[Non-text portions of this message have been removed]


------------------------ 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/