I have an application that's been in production for about 8-9 years.
It uses an Access database (I used the DAO 3.5 object library). At the
time, I provided a little utility that the end-user could run that did
a DBEngine.RepairDatabase and DBEngine.CompactDatabase on the app's
database. They have run this from time-to-time when they think the db
has gotten corrupted. From what I understand, it's actually did help a
couple of times.

I'm now in the process of doing a major upgrade on this program
(essentially an entire new program). I'm using DAO 3.60 this time.

They've asked me if the repair utility would work. I tried it and
found that it won't work. It's telling me that the RepairDatabase
method "is not available".

So - finally - my questions: Did RepairDatabase actually do anything
useful? Could I emulate its functionality some way?

Or should I just have it do the CompactDatabase? I notice in MS Access
itself, there is a tool entitled "Compact and Repair Database" - does
this do the same thing?

Thanks for any comments.

On Wed, 22 Feb 2006 09:42:38 -0700, Martin <martinval***@comcast.net> wrote:

¤ I have an application that's been in production for about 8-9 years.
¤ It uses an Access database (I used the DAO 3.5 object library). At the
¤ time, I provided a little utility that the end-user could run that did
¤ a DBEngine.RepairDatabase and DBEngine.CompactDatabase on the app's
¤ database. They have run this from time-to-time when they think the db
¤ has gotten corrupted. From what I understand, it's actually did help a
¤ couple of times.
¤
¤ I'm now in the process of doing a major upgrade on this program
¤ (essentially an entire new program). I'm using DAO 3.60 this time.
¤
¤ They've asked me if the repair utility would work. I tried it and
¤ found that it won't work. It's telling me that the RepairDatabase
¤ method "is not available".
¤
¤ So - finally - my questions: Did RepairDatabase actually do anything
¤ useful? Could I emulate its functionality some way?
¤
¤ Or should I just have it do the CompactDatabase? I notice in MS Access
¤ itself, there is a tool entitled "Compact and Repair Database" - does
¤ this do the same thing?

Yes, CompactDatabase will also perform a repair if necessary.

PRB: RepairDatabase Method Is No Longer Available in DAO 3.6
http://support.microsoft.com/default.aspx?scid=kb;en-us;294966


Paul
~~~~
Microsoft MVP (Visual Basic)

ByRef or ByVal
Event in VB raised more than once.
Is it DUMB to use the VB6 Timer to see if 24 HOURS have ELAPSED???
write ID3 to mp3 file
Problem displaying a TIFF file
Why won't VB6 control set install on WinXP pro SP2?
API File Req.
create primary keys on a view
"Compile error: User-defined type not defined"
How do I enter more than 1 variable into a Watch Expression