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/