Maintenance of Shoreware.mdb

[Ryland Junior Member Find all posts View Profile Close Ryland]

From working with the various people at TAC, a number of them have recommended running compress and repair to my database file. As to how often I get different responses, from every month to every six months.

Copy the shoreware data base file to a safe location. Make a second copy to your desktop and run the tool on this copy. Open up the database using access. If you go under tools you will find a compress and repair option. Run the option. Now here is the tricky part. In order to copy the database file back into the Shoreline Data/database folder you will need to stop the dcom/shoreline process. While stopped replace the file in the database folder. Now restart the DCOM/Shoreline process.

That should do it for you. Please do not do this unless you feel comfortable with messing with the database file. If you do mess up your system you can always replace your database file with the copy you put in a safe place.

[John_Lorenz Junior Member Find all posts View Profile Close John_Lorenz]

Another Caution

Running compress and repair should only be done at the request of Shoretel

This can damage your database and bring your system out of service.

[fyz Junior Member Find all posts View Profile Close fyz]

Hi,

Sometimes the backup of mdb file will also become damaged. I will try some tools to recover my file at that time. I would like to try a utility called Advanced Access Repair to repair my Access MDB file. It works rather well for my corrupt Access MDB files. But this rarely happens, so I just used it when necessary. Hope this is useful.

Alan