Compacting Access 2003 database

[ishfady]

Hi

I have Microsoft Access 2003 database ( mdb file).
Is there any way I can compact and repair my database though coding. I mean Visual Basic code.

So that every time close my access database, it will get compact and repair.

Please could you advice me.

many thank

 

[hymn]

part of your answer

http://www.mvps.org/access/general/gen0013.htm

Hope this helps
Hymn

 

[PHV]

I have Microsoft Access 2003
While in database window, menu Tools -> Options -> tab General: tick the Compact on close checkbox.
The spelling may be different as I don't use an english version of office.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kkitt]

Does anybody know of a way in VB Code to compact the BE Database for code in the FE.

thanks in advance

 

[kkitt]

Does anybody know of a way in VB Code to compact the BE Database from code in the FE.

thanks in advance

 

[evalesthy]

Take a look at thread:

thread705-885617

 

[KerryL]

Here's a link to some good information on how to compact one or multiple databases at a scheduled time. This allows you to compact the databases during off hours.

http://support.microsoft.com/?id=158937