Compacting and Repairing Database

IMPORTANT - Before compact and repairing your Database it is highly recommended that you first, perform a backup of your database. 

Browse to C:\The Service Program and double click on the bedatabase.txt file to open it.

 When the document is open it should look like this.

This shows you where your database is located. Browse to that location using Computer or Windows Explorer.

When you get to the folder where the database is located, you will see the database file, if you see the following (Icon with a lock on it) someone is still in The Service Program and you need to get them out before you can continue.

When you see the following you are good to continue.

Double click on the database and it will open in access.

Hit the Enable Content button and you will see the following.

On the top menu select the database tools button.

And then compact and repair database button

You will know it is working if you look at the bottom right hand side of the screen, you will see the following. When it is complete you can hit the red X in the upper right hand corner and your database has been compacted and repaired.

You can now restart The Service Program and others can access program as well.