jetengine compact reopening connection error
From: willem mooi wilten (mooiwilten_at_hetnet.nl)
Date: 05/31/04
- Next message: Marco: "strange EOleException error"
- Previous message: CC: "Re: sql ADOQuery problem with access 2000 database .mdb"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 30 May 2004 16:31:56 -0700
Hi everyone,
I'm using D7, ADO, ADOX, Ms Access database.
When i close a connection to compact an access database, reopening the
connection renders an errorno -2146825068 stating: "Supplied provider
is different from the one already in use."
Can anyone tell me what is going on?
really appreciate it!
Willem MW
(snippets)
with connection do
begin
close;
compact(); <-- successfully
open; <-- error reopening the database
end;
procedure compact() goes as follows...
...
try
...
try
JetEngine := CoJetEngine.Create;
JetEngine.CompactDatabase(SourceConnection,
DestinationConnection);
except
on E: Exception do
MessageBox(bla bla);
end;
finally
JetEngine:= nil;
end;
- Next message: Marco: "strange EOleException error"
- Previous message: CC: "Re: sql ADOQuery problem with access 2000 database .mdb"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
