SASnewbie
asked on
How is a Compact and Repair performed on a database that is not opened?
Hello,
I have databases with tables that are utilized by an Alteryx application as input and output. The end user will not be opening the databases.
The issue is the growth of the databases due to internal Access operations which can be close to 1GB in some instances.
Is there a way to set Compact and Repair for these databases without opening them?
Thanks
I have databases with tables that are utilized by an Alteryx application as input and output. The end user will not be opening the databases.
The issue is the growth of the databases due to internal Access operations which can be close to 1GB in some instances.
Is there a way to set Compact and Repair for these databases without opening them?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your quick response.
Is there a way to lock the database through VBA as well while performing the C&R?