98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2000
Access 2000
Resolved · Low Priority · Version 2000
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.
Tue 24 Mar 2009, 11:30Trainer Stephen said...
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.
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 tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
