Compact and Repair Access database

[jc]

Hello,

How do I programmatically Compact and Repair
an Access database?

I found several examples, on how to Compact and Repair
an Access database using VB, but I have not found any
examples using VC++/MFC.

TIA
-jc

[Scot Brennecke]

The code examples for VB to do OLE Automation of Access can be adapted
to VC++ (with MFC). The Type library for Access needs to be #imported,
and there will be smart pointer wrapper classed generated to do the same
things you can do in VB. It's not as tidy and simple as in VB, but it's
VC++, so you're working in a better language even if it isn't as
simplistic. :)

[Victor]

Compact using ADO:
http://support.microsoft.com/kb/230501
Compact using DAO:
http://msdn.microsoft.com/en-us/library/dsb6scf6.aspx
Repair using DAO:
http://msdn.microsoft.com/en-us/library/8ws24a09.aspx

Victor

"jc" <j...@discussions.microsoft.com> wrote in message
news:041A2EE1-72E0-4E08...@microsoft.com...