Recovering from a corrupt or missing database

If you get a message when starting up that the database cannot be found, or that it's corrupt and cannot be read, or if the Rack is completely blank, the first reaction is to panic.  This kind of error is usually caused by a power outage or computer glitch at just the wrong time, which causes the database to not be saved completely.  But unless you're using a very old version (before 2.0), then you can probably recover easily without losing anything.

There are simply too many possible variations in circumstance to show a simple step-by-step recovery procedure, but the guidelines below should get you through it easily enough.

Opening Campground Master

First you need to get Campground Master open and stable so you can use the Restore function if necessary.

If it says that no database has been defined, do NOT select the option to open the sample database.  Just let it open a blank database.  Then continue to the "No Database Defined" section below to try opening your database.

If it opens with a blank Rack, or if it shows one error message saying something like "database is corrupt" or "invalid database" and clicking OK brings you to a blank Rack or a login window, then continue to the next section.  (If your normal login doesn't work, use "Administrator" and "Password".)

If it shows a continuous stream of data error message prompts that don't stop after several messages, then close down (Ctrl-Alt-Delete and use End Task to terminate the program) and start over, opening the Demo database instead.  (If you've removed the demo icon from the desktop, go to Start / Programs / Campground Master and open the Sample database.)  Once the demo is open, use the Maintenance / New Database function to clear everything out -- if it asks for a name, try to enter exactly the same database name you used before.  If it says the database already exists, that's OK -- that's the corrupt one anyway so you might as well clear it out.  Once you have a blank database open, skip to the "Do you have a removable backup..." section below.

No Database Defined, or a blank Rack?

If it says that no database has been defined, or if it opens with a blank Rack, then it could simply be that it lost track of which database it was supposed to open.  Use File / Open to see if you can find your database file.  The folder "C:\Program Files\Campground Master" is the most likely location for Windows 95, ME, 98 and 2000, or "Shared Documents" for Windows XP, or "Public Documents" for Windows Vista or later.  If all else fails, use the Find Files function in Windows (form the Start button), and look for files named *.prk (include the asterisk and the period).  If it finds one (other than "demo.prk") and it looks like your database (check the modified date -- is it recent?), make a note if its location and then use File / Open again to open it.  Otherwise, continue with the steps below.

Important: Do NOT open a database named "database.prk" that's inside a .zip file (that's a compressed backup, and will show a zippered folder instead of a normal folder icon).  If this is the only database you can locate, then you should use the Restore function covered below.

If you can't find your database or it's still blank, then keep reading...

Do you have a removable backup, e.g. on floppy or CD?

Ideally you're making daily backups to a removable disk (if not, YOU SHOULD), in which case it's a simple matter of using the Maintenance / Restore from backup function to restore the database.  Just follow the prompts, locate the backup file on the removable disk when you get to the Open dialog, and open that file.

Important: After restoring the database backup, if it didn't prompt you to use the same last database file, then be sure to use File / Save As to save it to the correct location on your hard drive, with the correct name.  When you get to the Save As dialog, double-check the "Save In" location -- usually it will show "Campground Master", and if you drop down the list then it should indicate that it's under C:\Program Files.  If it shows something else, see if a database file is shown with the name you normally use.  If so, then that might be the correct location -- just select it to replace the file there (presumably it's corrupted).   If you can't figure out where the database used to be saved, then we recommend that you put it in C:\Program Files\Campground Master\ for Windows 95, ME, 98 and 2000, or "Shared Documents" for Windows XP, or "Public Documents" for Windows Vista and Windows 7 or later.

If you're using a version older than 3.1, you should immediately close Campground Master and re-open it after doing the Save As step.  This will force it to check for changes in the log files that didn't get in the backup, and those can be restored also.  If you're using 3.1 or later, it should prompt you to "Apply changes" after you do the Save As step (click 'Yes' when it does).

Note: In order to recover changes made since the backup, the database must be saved in the same location that was used before, and must use the same filename.  If you don't remember where it was saved and it's not in the path mentioned above, you could check Maintenance / Program Options / Database to see if it shows the auto-open path.

What if you don't have a backup handy?

There's still hope, if you're using a recent version.  The program makes daily auto-backups which should still be there.  These are placed in the same folder as your database (usually in C:\Program Files\Campground Master\ for Windows 95, ME, 98 and 2000, or "Shared Documents\Campground Master" for Windows XP, or "Public Documents\Campground Master" for Windows Vista and Windows 7 or later).  So try using the Maintenance / Restore function, and when it gets to the Open dialog then navigate the Look In drop-down list to that location (select the disk under My Computer that shows "(C:)", then double-click the Program Files folder, then double-click the Campground Master folder).

Now you should see a whole bunch of files that start with your database name and then have "_Auto_Backup_" and a date in the name (make sure the Files of Type shows "Compressed backup (*.zip)").  Locate the one with the latest date in the filename, select it and click Open.  If it's still blank, then that means the one you opened was an auto-backup of the blank database you already have open -- so look for the Auto-Backup with next most recent date and try that one.

If you didn't see these auto-backup files in that location, then you may have been saving your database somewhere else.  If you don't remember where it was saved, you could check Maintenance / Program Options / Database and see if it shows the auto-open path.  If all else fails, use the Find Files function in Windows (form the Start button), and look for files named *_Auto_Backup_*  (include the asterisks, those are wild-card characters).

What if it's on a networked computer?

If the problem is on only one computer in a networked setup (even if it's the "master"), then you can also just make a fresh backup from one of the other computers and restore it to the corrupted one.  Be sure to save it using the same database name as the other workstations use, or else it won't be able to connect to the server.

Making sure it continues to open the correct database

Once you have your data restored and you've verified that it's as good as can be expected, then there may be a couple more steps to make sure it opens this database automatically.  This is especially true for version 3.5 or later, but in any case you should follow this procedure:

1. Use File / Save As to save the database.  It should default to the correct location, but if not then verify that the "Save In" drop-down shows "Campground Master" (unless you're using a different location on purpose).  It should also show the database file already in the file list and the File Name field.  If not, enter the database name you want to use (e.g. your park's name).  Click Save to save the data to that file.  If it warns you that the file already exists, that's OK.  If it asks you if you want to use this as the new default database, click Yes.

2. Use File / Open to open the database, verifying that it's correct.  (You should be able to just click Open -- the file name and location should already be selected.  If not, you'll need to navigate the Look In to the proper location and select the database file.)

3. Log in (using an administrator-level login), and go to Maintenance / Program Options / Database.  If there's a large button "Change the auto-open database..." underneath the auto-open database file and path, then click that button.  (This will only be there for version 3.5 and later.)

Hopefully the procedures above will get your data restored.  If you have any problems, please contact us.