INSERT INTO from password protected database

Article View: borland.public.delphi.database

Article #244

Back to borland.public.delphi.database Previous Next

#244

From: Petar Tomic
Date: Mon, 01 Jul 2002 05:24

14 lines
1341 bytes

I am using two Access 2002 databases, with their Database Passwords
set.
How do I insert into a database that is password protected, from
another password protected database?
When i try
...
ADOConnection1.Execute('Insert Into Table1 Select * from UpdateTable
in '+ QuotedStr(ExtractFilePath(ParamStr(0)) + 'Update.mdb'));
...
I got the error "Project raised exception class EOleException with
message 'Not a valid password'.
Source table and target table have the same layout but in different
databases.
Thanks for any help.

Technical Details

Message-ID: <51c444b7.0206302124.970f318@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,6feb0cb69db30708,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2002-06-30 22:24:37 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: vscar@hemo.net (Petar Tomic)
Newsgroups: borland.public.delphi.database
Subject: INSERT INTO from password protected database
Date: 30 Jun 2002 22:24:37 -0700
Organization: http://groups.google.com/
Lines: 14
Message-ID: <51c444b7.0206302124.970f318@posting.google.com>
NNTP-Posting-Host: 194.106.161.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1025501077 22692 127.0.0.1 (1 Jul 2002 05:24:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 1 Jul 2002 05:24:37 GMT