When you start QuickMap or a layer is manually turned on, you may get this error:
The Microsoft Jet database engine cannot find the input table or query ‘<<layer name>>’. Make sure it exists and that its name is spelled correctly. WktSet::Query SELECT <<layer name>>.ID,GP,Label,FileName,xmax,ymax,xmin,ymin FROM <<layer name>>WHERE ID = 0
This is because a user has created a layer and then deleted or moved the source database.
To fix this use the QUtility application (from the QUtility Folder either on a recent Disk 2 or from the QMap Folder in Windows Explorer.) Then correct the location of the data.
In the example below QuickMap is assumed to be the C:\QMap folder and the layer name is assumed to be myoldstuff. Both of which, of course, will need to be changed to the appropriate value for individual needs.
- Make a backup copy of C:\ QMap\QMap.mdb
- Run C:\ QMap\QUtility.exe
- Copy and paste the following into the SQL box and press run
DELETE * FROM [QDefaultTable] WHERE [qLayer] = ‘myoldstuff’
You should be advised that 1 record has been updated. If not, check that your details are correct. - Copy and paste the following into the SQL box and press run
DELETE * FROM [qLayers] WHERE [LayerName] =’myoldstuff’
Again you should be advised that 1 record has been updated.