PC Review


Reply
Thread Tools Rate Thread

How to compact an Access Database under VB.Net?

 
 
Georges Bessis
Guest
Posts: n/a
 
      28th Oct 2005
Hi,

In VB6, and DO, I used to progam this simply by
Compactdatabase(SOurce, Destination)
And also I used : repairdatabase (MyDataBase)
These where standard DAO.DBEngine methods

How do I do that in pure VB.Net?
Thanks in advance

GB6


 
Reply With Quote
 
 
 
 
Paul Clement
Guest
Posts: n/a
 
      28th Oct 2005
On Fri, 28 Oct 2005 21:06:56 +0200, "Georges Bessis" <(E-Mail Removed)> wrote:

¤ Hi,
¤
¤ In VB6, and DO, I used to progam this simply by
¤ Compactdatabase(SOurce, Destination)
¤ And also I used : repairdatabase (MyDataBase)
¤ These where standard DAO.DBEngine methods
¤
¤ How do I do that in pure VB.Net?
¤ Thanks in advance

You can either use DAO or JRO. There is no native method because there is no native provider for the
Jet database engine.

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


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't compact Access 97 Database John S. Ford, MD Microsoft Access 1 22nd Nov 2004 11:32 AM
How to Compact an Access Database in VB.NET? Neal Microsoft VB .NET 2 23rd Nov 2003 08:10 AM
Compact Access Database Brian P. Hammer Microsoft VB .NET 2 22nd Sep 2003 03:13 PM
Access 97 Compact Database Tim Bocek Microsoft Access 2 6th Aug 2003 11:33 PM
Why compact an Access Database? Charles A. Lackman Microsoft ADO .NET 3 12th Jul 2003 07:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:01 AM.