Re: Compact/Repair Access 2007 database
- From: "Andy" <andy@xxxxxxxxx>
- Date: Thu, 1 Nov 2007 05:31:52 -0400
Hi Mike,
I tried Benedictum's password connectionstring but I get "Invalid argument".
Any idea where I went wrong?
Thanks for helping out.
Andy
"MikeR" <nf4lNoSpam@xxxxxxxxx> wrote in message news:47289e2d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Andy wrote:Hi Mike,Hope it works for you, Andy.
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.
'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
.
- Prev by Date: Re: Compact/Repair Access 2007 database
- Next by Date: Re: REQUEST: Test tool
- Previous by thread: Re: Compact/Repair Access 2007 database
- Next by thread: Re: REQUEST: Test tool
- Index(es):
Relevant Pages
|
