Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2000
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access 2000
Resolved · Low Priority · Version 2000
Reply Fri 20 Mar 2009, 16:38Delegate Nick said...
Nick has attended:
Access Intermediate course
Access VBA course
Access Advanced course
Access 2000
Hello,
Is it possible to have Access automatically compact and repair a database.
For upcoming training course dates see: Pricing & availability
RE: Access 2000
Hi Nick
Thank you for your question
It is possible to write a VBA procedure that will compact and repair the database. This uses the CompactRepair method of the application object.
Its use is fairly complex and a detailed description is beyond the scope of the forum. While it is not specifically covered on the VBA Access course, you will acquire the skills required to interpret and apply it.
For the moment further information can be gained by typing CompactRepair into the VBE help box
Regards
Stephen
Tue 31 Mar 2009: Automatically marked as resolved.
|