Auto compact script (1 Viewer)

npa3000

Member
Local time
Today, 14:37
Joined
Apr 16, 2021
Messages
36
Hello, i have made a script that compacts my access project based on a daily scheduled task.

The command is:
"MSACCESS.EXE" "\\server\DB_BE.accdb" /compact "\\server\DB_BE.accdb"

It works, but every time it runs, i get a warning that says that the new name is the same with the old one. How can avoid that?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:37
Joined
Oct 29, 2018
Messages
21,357
Hi. You could try using a different name first and then replace the original with the compacted copy. By the way, where are you executing this script? It is not recommended to perform a compact over the network.
 

Users who are viewing this thread

Top Bottom