How to compact an Access database in VBA?

👉 Take advantage of the launch offer of -50% with the promo code MINITOOL50 until this Sunday at 11:59 PM (Paris time): www.votreassistante.net/appli...
🚨 ALL THE INFORMATION IN DESCRIPTION (CLICK ON "MORE") 🚨
#TutoAccess #AccessVBA #Access #MSAccess
🔴 To have access to the method to create your own application on Access quickly and without being an IT expert, go here: www.votreassistante.net/forma...
🙋 Join the Votre Assistante Facebook group to share tips and tricks around #Word, #Excel, #Access, #PowerPoint, #VBA, #Photoshop and #Illustrator software: / votreassistante
⚠️ To better view the video, I advise you to set the quality of the video to HD by clicking on the toothed wheel (↓ at the bottom right → of the video). ⚠️
📢 To be informed of the publication of future articles, subscribe to the newsletter and receive the checklist to create the Access application that will make you more productive and efficient: formations.votreassistante.ne...
🚨 Subscribe to the channel by clicking on Subscribe (just above ↑) then on the 🔔 next to not miss any video 😉
Tutorial made with Access Microsoft 365
Video tutorial to learn how to compact an Access database in VBA and how to compact another Access database in VBA.
🔗 To access the text version of this tutorial, go to Votre Assistante: www.votreassistante.net/comme...
☑️ Useful links:
- www.votreassistante.net/pourq...
- www.votreassistante.net/appli...
- www.votreassistante.net/forma...
📖 Summary:
00:00 Introduction
00:50 1. How to compact an Access database manually?
01:09 2. How to compact an Access database in VBA when closing the file? - 2.1. Creation of the button to compact the database
03:13 2.2. Writing the procedure to compact the database
06:32 2.3. Creation of the button to no longer compact the database
07:23 2.4. Writing the procedure to no longer compact the database
08:57 3. How to compact an Access database from another database?
09:23 3.1. Creation of the Access database, its form and its button
10:32 3.2. Writing the procedure to compact another Access database
14:59 4. Presentation of the new Access utility software of Votre Assistante
🚀 To go further, discover the Méthode T.R.I.P.L.E. to go to the next level with Access: www.votreassistante.net/forma...
🚀 To go further, discover the application Gérez vos devis et factures avec Access: www.votreassistante.net/appli...