3078: The Microsoft Jet database engine cannot find the input table or query '<TableName>'. Make sure it exists and that its name is spelled correctly.

Published: November 5, 2008

 

Last Updated: 2009-12-17

Applies To

Symptoms

When opening Guard1 Plus you receive the following error:

 

 

Where <TableName> is the name of the affected database table.

 

Cause

 

Resolution

Restore your data from a Backup..

 

If you do not have a Backup, you will have to start from scratch with a new database:

  1. Delete the corrupt master database:
    1. Close Guard1 Plus.
    2. Open My Computer and navigate to C:\Program Files\Guard1 Plus (or C:\TimeKeeping Systems\Guard1 Plus if Windows Vista.)
    3. Right-click the file G1Master.g1p and select Delete, the click Yes. NOTE: depending on your Windows View settings, you may not be able to see the .g1p file extension. Choose the G1Master file with the large blue "1" icon.
  2. Open Guard1 Plus. You will see a message stating "Now setting up master database...please wait."

 

Guard1 Plus has created a new, empty database. You will have to set up your Buttons and Facilities from scratch.  DO NOT restore your data from the old database - doing so will import the corrupt tables to your new database, causing the same problem with the new file.

 

See Guard1 Plus Data Maintenance for information on how to prevent database problems.

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.