The Microsoft Jet Database Engine Cannot Find The Input Table Or Query ‘Layer Name’

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.

  1. Make a backup copy of C:\ QMap\QMap.mdb
  2. Run C:\ QMap\QUtility.exe
  3. 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.
  4. 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.

Comments are closed.