Re: Compact/Repair Access 2007 database

From: MikeR <nf4lNoSpam@xxxxxxxxx>
Date: Wed, 31 Oct 2007 11:24:29 -0400

Andy wrote:

Hi Mike,

Thanks for responding and the code snippet. I tried it using the following
for SProvider1:

SProvider1 := 'Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Jet OLEDB:Database Password=ppp;Jet OLEDB:New Database Password=ppp;Data Source=' ;

But it gives me the following errors:

'Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.'

Any idea where I went wrong?

Thanks again.

Hope it works for you, Andy.
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + DBName + ';Jet OLEDB:Engine Type=5'; is one string I use.

Benedictum's link should get you going better.
Mike
.

References:
- Compact/Repair Access 2007 database
  - From: Andy
- Re: Compact/Repair Access 2007 database
  - From: MikeR
- Re: Compact/Repair Access 2007 database
  - From: Andy

Prev by Date: Re: NativeJpg now available at introductory price
Next by Date: Re: Traffic a little slow in this NG ?
Previous by thread: Re: Compact/Repair Access 2007 database
Next by thread: Graphic Components
Index(es):
- Date
- Thread

Relevant Pages

Re: Compact/Repair Access 2007 database
... for SProvider1: ... SProvider1:= 'Provider=Microsoft.ACE.OLEDB.12.0;Persist Security ... 'Multiple-step OLE DB operation generated errors. ... //close the database here ...
(borland.public.delphi.thirdpartytools.general)
Re: Compact/Repair Access 2007 database
... Thanks for responding and the code snippet. ... for SProvider1: ... 'Multiple-step OLE DB operation generated errors. ...
(borland.public.delphi.thirdpartytools.general)
Re: Compact/Repair Access 2007 database
... Thanks for responding and the code snippet. ... for SProvider1: ... 'Multiple-step OLE DB operation generated errors. ... //close the database here ...
(borland.public.delphi.thirdpartytools.general)