When I try to open Guest Tracker it says that the Database is 
"in use by another Database Utilities user."

Overview
When you try to enter Guest Tracker you get the following error message:

DB in use by another...

Guest Tracker was not able to perform the normal exit routines and the program thinks that another user is still backing up or restoring the database.

Solution
This error message only existed in Version 3.0 of Guest Tracker. You need to visit the Support area and download the version 3 update. After you have done so, the error message will become more specific about the problem.

After upgrading to version 3.1, it is easy to resolve this issue by running Database Utilities Verify and Compact as described on Pages 294 and 295 of the Guest Tracker User's Guide.  

Procedure
1) If you have not already done so, click the OK button to clear the error message from the screen.
2) Start the Guest Tracker Database Utilities program as shown below.

START: Programs: Guest Tracker: Database Utilities
3) From the Guest Tracker Database Utilities window, click the Verify button. 

Database Utilities window
4) The name of your current Guest Tracker database is displayed in the filename field.  Verify that this is the correct database, and then click the OK button to proceed with the verification.  

Verify: Select a database window
5) When the verification is complete a status message is displayed. Click the OK button.

Verified successfully!
6) Now you are ready to compact the database.  From the Database Utilities window, click the Compact button.

Database Utilities window
7) The name of your current Guest Tracker database is displayed in the filename field. Click the OK button to proceed with the compaction.  

Compact: Select a database window
8) When the compaction is complete, you will be offered an opportunity to save a backup copy of your database.
Click the Yes button to proceed if you wish to save the backup copy.
Click the No button to proceed if do not wish to save the backup copy.

Compacted Successfully!
9)

You are done verifying and compacting your Guest Tracker database.  Click the Exit button to quit the Database Utilities program. 

10) Start the Guest Tracker program. 
11) Your Guest Tracker database is displayed.

This site and all portions are Copyright 1993-2011 RezOvation LLC, a BedandBreakfast.com partner.