MS Access Compact & Repair database option - AndreaVB Visual Basic and VB.NET source code discussion board

Previous Topic (how to refresh an access DB)

Next Topic (MSHFlexGrid Date Format ...)

AndreaVB Forum : Database : MS Access Compact & Repair database option

Poster

Message

ahmad
Level: Master

Registered: 03-02-2003
Posts: 120

MS Access Compact & Repair database option

G.Day Every one
there is an option is ms access Tools + atabase utilities Menu
called MS Access Compact & Repair database
Can we make a code in VB that can call that option and do it.
regards
Ahmad

____________________________
@#@#@

21-07-2006 at 06:24 AM

GeoffS
Level: VB Lord

Registered: 29-09-2004
Posts: 536

Re: MS Access Compact & Repair database option

Hi,
You can do it with DAO.

DBEngine.RepairDatabase (dbname)

DBEngine.CompactDatabase (olddbname, newdbname, locale, options, password)

____________________________
multi-tasking - the ability to hang more than one app. at the same time.

21-07-2006 at 08:32 AM

yronium
Level: Moderator

Registered: 14-04-2002
Posts: 907

Re: MS Access Compact & Repair database option

Hello.
You might want to have a look on these older threads:
this one, this other one, this other, this one too, or even this, ... and of course my final solution.

Hope it helps

____________________________
Real Programmer can count up to 1024 on his fingers

24-07-2006 at 02:06 PM

AndreaVB Forum : Database : MS Access Compact & Repair database option


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincani