In Vista, Microsoft added security so that whenever you copy or write files under the Program Files folder and you are not logged in as an administrator user, it puts "virtual" copies of the files in a hidden folder ("Compatibility Files"). So first off, if you are running Vista, be sure you are logging in as an administrator user when you startup the computer always, and if the user you are logging in as for some reason is not setup as an administrator user, then make them be.
Another thing to do in the Windows Explorer (Start > My Computer > View pull-down option at the top, choose Details) go to Tools > Folder Options > View, and find the option that says "Hide extensions for known file types", and uncheck that. That way, when you browse to C:\Program Files\Camelot\Database (or Camelot3\Database for 3.0 users) you can see the full file names.
For Camelot 2.6.x, your actual database file is the "Data.mdb" file, and the "Wrkgrp.mdw" file is the file that holds your usernames and passwords. The "Data.ldb" and "Wrkgrp.ldb" files (the "locked" ones you may see there) are temporary files that are there only when you are connected to the database.
In Camelot 2.6.x, if you've had the problem of suddenly losing your database or opening Camelot only to find a blank database, then you need to first restart the computer, make sure you are logging in as an administrator user, and then go to that C:\Program Files\Camelot\Database folder, choose that "Compatibility files" option, and right-click on the Data.mdb file and choose Cut, and then go back to the regular view of the Database folder, and right-click on it and choose Paste. Do the same for the Wrkgrp.mdw file. Then close and reopen the windows explorer and be sure you can see the Data.mdb and Wrkgrp.mdw files there without going to "Compatibility files".
For Camelot 3.x, your actual database file is the C:\Program Files\Camelot3\Database\CAMDB.FDB file. So you would follow the same steps as above, but cut and paste that file instead.
Turning off Vista's User Account Control:
1. Click Start and then open Control Panel.
2. In the Control Panel, click User Accounts and Family Safety.
3. Click User Accounts.
4. Click Turn User Account Control on or off.
5. Clear the tick or check mark on the box beside the Use User Account Control (UAC) to help protect your computer option.
6. Click OK.
7. When prompted, restart the computer.
TIP: If you are running Windows Vista, then right-click on the Camelot icon on your desktop and choose Properties, and check run in compatibility mode for w2k. That should also help avoid these sorts of issues.
keywords: windows vista, microsoft, compatibility, blank database, lost database, empty database, lost data, no data, microsoft vista, compatability