This article gives step-by-step instructions for repairing a database.
The second level repair of a database involves using Database Utilities to create a new, blank database and copying all data in the corrupted database, field by field, into the new database. The old database should be renamed, and the new database given the name of the old database.
- Make sure that the Quick Vic database is not being accessed by any users. e.g Close any running copies of Quick Vic Central Reporting Program and also the Update Server program (if it is running).
- Use Windows Explorer to rename the current, corrupted database.
- Open the Database Utilities program. Click Database -> Create Access Database.
- In the Database Name field, enter the full path and the same file name as the corrupted database, prior to you renaming it and click the Save button. Click the Create button and wait while the Database Creation window completes its steps.
- Click OK.
- Again in the Database Utilities’ program, click Database -> Copy Database.
- Click the Browse button for the Source Database and select the old database.
- Click the Browse button for the Target Database and select the newly created database you created in step 4.
- Click the Copy button when ready to proceed.
- Click Yes to confirm that you wish to proceed, and wait while a Database Copy window performs a series of processes, displaying progress as it is so doing. This may take some time, depending on the size of the database. When completed a message will be displayed confirming whether the repair was successful.
The database will now be repaired and ready to use.