VBA CODE TO COMPACT DATABASE

[Musoke]

Hullo People, does any one have a VBA code that can compact a database

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[arnelgp]

you need an External db to compact the current db.

 

[NauticalGent]

Check this out:

Access - VBA - Compact a Database | DEVelopers HUT

A brief discussion about compacting and sample illustrating how to accomplish it through VBA coding.

www.devhut.net