-4

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.

Erik A
  • 31,639
  • 12
  • 42
  • 67
Makine
  • 1
  • 2

2 Answers2

1

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

Gustav
  • 53,498
  • 7
  • 29
  • 55
0

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.

KySoto
  • 399
  • 2
  • 7