Answers for "how to compact and repair access database in vba"

0

how to compact and repair access database in vba

If you want to compact/repair an external mdb file (not the one you are working in just now):

Application.compactRepair sourecFile, destinationFile

If you want to compact the database you are working with:

Application.SetOption "Auto compact", True
Posted by: Guest on March-31-2021

Browse Popular Code Answers by Language