Repair an Access database from .NET

[Roy]

Hi all,
With use of Microsoft Jet and Replication Objects 2.x Library, I can compact
an Access database. But is there any way to Repair an Access database from
VB.NET?
Thanks in advance.
Roy

[Crouchie1998]

Hi Roy,

This page shows how to compact/repair an Access Database with VB.NET:

http://support.microsoft.com/default...b;en-us;306287

I hope this helps

Crouchie1998
BA (HONS) MCP MCSE

[Roy]

I just need to make sure repairing is also done along with the compacting.

"Crouchie1998" wrote:

Hi Roy,

This page shows how to compact/repair an Access Database with VB.NET:

http://support.microsoft.com/default...b;en-us;306287

I hope this helps

Crouchie1998
BA (HONS) MCP MCSE

[Paul Clement]

On Tue, 5 Jul 2005 11:27:02 -0700, Roy <Ro*@discussions.microsoft.com> wrote:

¤ I just need to make sure repairing is also done along with the compacting.
¤

Yes, JRO does both.
Paul
~~~~
Microsoft MVP (Visual Basic)

[J L]

Paul,
When you add JRO to the project, will that necessitate registering the
component at install time? I am trying to keep with XCOPY deploy and
wonder if JRO is compatible with that? Hope that question makes sense.

TIA.
John

On Tue, 05 Jul 2005 14:49:30 -0500, Paul Clement
<Us***********************@swspectrum.com> wrote:

On Tue, 5 Jul 2005 11:27:02 -0700, Roy <Ro*@discussions.microsoft.com> wrote:

¤ I just need to make sure repairing is also done along with the compacting.
¤

Yes, JRO does both.
Paul
~~~~
Microsoft MVP (Visual Basic)

[Paul Clement]

On Tue, 05 Jul 2005 20:18:57 -0700, J L <jo**@marymonte.com> wrote:

¤ Paul,
¤ When you add JRO to the project, will that necessitate registering the
¤ component at install time? I am trying to keep with XCOPY deploy and
¤ wonder if JRO is compatible with that? Hope that question makes sense.
¤

Well MDAC should be installed (a .NET framework requirement for version 1.0 and 1.1) so that will
take care of the JRO COM registration. The only other file you should need is the interop assembly
(Interop.JRO.dll) that is created when you add JRO to your project. Just XCOPY that file to the bin
folder with your other assemblies.
Paul
~~~~
Microsoft MVP (Visual Basic)