Compact the current database

238 views Asked by At

Compact the current database, without closing it? Access 2016. VBA. As a friend said, you need to press to compress or restore database on the tape.

2

There are 2 answers

0
Gustav On

True. Wonder have you can imagine it being compressed without being closed.

0
KySoto On

When you press the compact and restore button, access actually closes the file, makes a copy, performs the compact and restore on the copy, then overwrites the original. So sadly, you cant do what you want to do.