Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to schedule an unattended auto compress in Access 2000?
3 replies
The simplest way is to use the access command line option /compact
You can get details of this by asking the office assistant for "compact command line".
To run it automatically, you could use a scheduling program such as windows scheduler from the Start button, go to Programs|Accessories|System Tools|Scheduled Tasks and Add Scheduled Task.
You must make sure that the database, or databases, you want to repair/compact are closed before the operation begins because the operation needs exclusive access to succeed.
HTH
John
by lynne
Perfect! I wrote a little batch file that's kicked off in the scheduled tasks and using the command.
by lynne
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
0 helpful
20 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
Discussion
Network Printer Works for Everyone Except Me
0 helpful
10 replies
0 helpful
4 replies