"The SQL for this report is invalid" message
If you get this error message when trying to open a report either to preview it or go into its layout/design, it means one of the following:1. The criteria for the report is not valid. Double-click on the report again to access its criteria screen, and be sure there is nothing wrong there. Try ...
- Authorization Codes Needed / How do I get new authorization codes?
Authorization Codes are needed to open the software The software is protected from piracy through the use of authorization codes. After having the program installed for the initial 30-day period, or after re-installing the software onto a new computer, you will need to get new authorization code ...
- Calculating Commissions Troubleshooting - Applying Commissions
If you are having trouble getting your commissions to figure right when you view the results in the Technician Commissions Report, then you may want to follow these steps to be sure that you have your commissions setup and applied to the orders like you want: 1. From the Misc/Setup pull-down men ...
- Camelot3 and Windows 2003 Server
If you are running Camelot3 on a Windows 2003 Server, and it seems to be running slowly, check the following:1. If you have CPU that supports hyperthreading try disabling it to see if that helps. If you can multi-core a CPU (dual core, quad core), set the CPUAffinity setting in firebird.conf ac ...
- Camelot3 Date range issues
If you are experiencing criteria or funnel entries that are no longer working like you thought after upgrading to Camelot3 from previous editions of Camelot, then one likely reason has to do with date ranges.In Camelot3, any "is between" date range criteria row must have the older date on the le ...
- Cannot find file
If when attempting to open the program, you get an error that says Cannot Find File, then this means that either your Camelot program folder has been moved, or the database file(s) it uses have been moved or deleted.First, go to My Computer, the browse to the location where your Camelot program ...
- Cannot login to Camelot3
Camelot3 uses a Firebird database. If you are having trouble logging into Camelot3, then it is either because:1. You are using an incorrect username or password. These items are case-sensitive, so being sure you are using the proper upper or lower case. The default login for Camelot3 is usernam ...
- DAO Error...
PROBLEM / ERROR: “DAO Error...” Common types: Record is deletedNo Index for fieldNo current recordDataset not in edit or insert mode ( Data set not in edit or insert mode ) Usually these errors mean that the database needs to be compacted. Close out of the program on all machines, then from your ...
- Error - Access Violation
If you ever get an error message that says something like "Access Violation at address...", that means that there was an error in accessing some part of memory on your computer. If the error pops up repeatedly after you click OK on the error message, then end the Camelot program task by pressing ...
- Error - Cannot start your application...
PROBLEM / ERROR: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. This usually means that for some reason, the workstation cannot find the database files that are shared on the Server. This could be because the server machine is not ...
- Error - Unrecognized Database Format
PROBLEM / ERROR: “Unrecognized Database Format” This problem can sometimes be corrected simply by running the Camelot Database Utility program (Start > Programs > Camelot > Camelot DB Utility) and choosing to Compact/Repair database files. If this doesn’t work, then you must restore fro ...
- Error opening database (Windows 95 or Windows 98)
NOTE: This error would only happen possibly on a Windows 95 or 98 installation, and should not happen on a 2000 or XP installation, since the MDAC is a part of those operating systems. Problem: After installing, you get an error message like "Error opening database" or "DLL file missing..." Some ...
- Error opening query for the chosen report
You would most likely get this error because you have invalid criteria entered for a report. Please refer to the topics about the Criteria screen for help on setting up criteria. If you are getting this error when attempting to print or preview your route sheets, it is again for this same reason ...
- Error: Executable DBVersion (###) does not match database (###)
This error means that the program you are running is older than the database you are trying to connect to.This usually happens when reinstalling. Be sure you are using the most recent CD that you received. Also, it is likely that you downloaded some update in the past, and so you need to install ...
- Network Installation - non-primary user can't open program after install
Any workstation on a network that connects to the database on another computer needs to have full read/write permissions to the Windows Registry key used by Camelot. This is so that when the program opens, it will be able to access that registry key to see where it needs to connect to the databa ...
- Problem: Unable to login
If you are getting a login screen and you are unable to login, and there is no other error message appearing before you get this login screen, then you may simply have a corrupted workgroup information file (the file that holds user names and passwords). This file only really changes when you ad ...
- Support options
Camelot offers free 24-hour web support via our searchable web knowledgebase. Also, you can submit questions to us for email response by clicking here.Additional support is available by calling 1-888-590-1696 and choosing the option for support in the phone menu. keywords: support, tech suppor ...
- Tax Calculation Troubleshooting - Problems with Taxes
These instructions take you through every place in the program where the tax setup comes into play. Follow these closely, and you should solve whatever tax problems you may be having. 1. Go to Misc/Setup pull-down menu and choose Company/Misc. Info. 2. Go to the Tax Rates tab. 3. Confirm that th ...
- Vista - Compatibility Files
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 ar ...
- Vista - Disabling User Account Control
Disabling User Account Control in Windows Vista: Ensure you are ALWAYS logging into the computer using a Windows Administrative account Click the Start icon Click Search Type “msconfig” (without the quotes) Click OK Click the Tools menu, highlight Disable UAC Click Launch Af ...
