This is a helpful topic for the Users of Advance Vessel ERP Interface System of Advance Engineers
To compact and repair an MS Access database, follow these steps:
Close the database and make a backup copy of it. It's always a good idea to make a backup before performing any database maintenance.
Open Microsoft Access and click on the "File" tab.
Click on "Info" and then click on "Compact & Repair Database."
In the "Compact & Repair Database" dialog box, navigate to the database you want to compact and repair.
Click on the "Compact" button to start the process. This may take some time depending on the size of the database.
Once the process is complete, you will see a message confirming that the database has been compacted and repaired.
Click on "OK" to close the message box.
Close and reopen the database to ensure that everything is working properly.
Note: It's recommended to perform this maintenance task regularly to keep the database running smoothly.
Happy Support