compacting access databases in vb .net

[ray well]

hi,

i have an access database file attached to an app via ado, that needs to be
compacted and repaired from time to time. in regular vb i would do it thru

DBEngine.CompactDatabase sDataBaseBackupFile, sDatabaseFile
how do this in vb .net ado ?

i would appreciate a snippet of code, and if i have to add a referencer in
my solution to some specific file.

thanks for any help

ray

please respond to the list

[Herfried K. Wagner [MVP]]

* "ray well" <no****@nospam.com> scripsit:

i have an access database file attached to an app via ado, that needs to be
compacted and repaired from time to time. in regular vb i would do it thru

DBEngine.CompactDatabase sDataBaseBackupFile, sDatabaseFile
how do this in vb .net ado ?

i would appreciate a snippet of code, and if i have to add a referencer in
my solution to some specific file.

ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Armin Zingler]

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> schrieb

* "ray well" <no****@nospam.com> scripsit:

i have an access database file attached to an app via ado, that
needs to be compacted and repaired from time to time. in regular vb
i would do it thru

DBEngine.CompactDatabase sDataBaseBackupFile, sDatabaseFile
how do this in vb .net ado ?

i would appreciate a snippet of code, and if i have to add a
referencer in my solution to some specific file.

ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

I think you can _not_ compact an access database with ADO.NET.
Ray, you can use JRO ("Microsoft Jet and Replication Objects 2.6 Library")
via COM interop to compact a database. See JRO.JetEngine.CompactDatabase.
--
Armin

[Herfried K. Wagner [MVP]]

* "Armin Zingler" <az*******@freenet.de> scripsit:

DBEngine.CompactDatabase sDataBaseBackupFile, sDatabaseFile
how do this in vb .net ado ?

i would appreciate a snippet of code, and if i have to add a
referencer in my solution to some specific file.
ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

I think you can _not_ compact an access database with ADO.NET.

I know that... But I think that's the better place to ask the question.

;-)
Ray, you can use JRO ("Microsoft Jet and Replication Objects 2.6 Library")
via COM interop to compact a database. See JRO.JetEngine.CompactDatabase.

ACK.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Paul Clement]

On Wed, 22 Oct 2003 10:38:54 -0400, "ray well" <no****@nospam.com> wrote:

¤ hi,
¤
¤ i have an access database file attached to an app via ado, that needs to be
¤ compacted and repaired from time to time. in regular vb i would do it thru
¤
¤ DBEngine.CompactDatabase sDataBaseBackupFile, sDatabaseFile
¤ how do this in vb .net ado ?
¤
¤ i would appreciate a snippet of code, and if i have to add a referencer in
¤ my solution to some specific file.
¤

Here is the MS KB article:

HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
http://support.microsoft.com/default...&Product=vbNET
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)