How To Fix Access Database Error 3078 – “Can’t Find The Input Table Or Query”?

Looking for some instant fixes to resolve MS Access Run-time Error 3078: ‘The Microsoft Jet Database Engine Cannot Find the Input Table or query? Well in that case this particular blog will surely be going to help you a lot. 

As the following post contains fixes for this Microsoft jet database error 3078.

Let’s start a comprehensive discussion on the one of the most frequent error that user faces in Microsoft Access i.e Run-time Error 3078 “The Microsoft Jet Database Engine Cannot Find the Input Table or query”.

Practical Scenario:

Hello,

I have to help somebody who has an application which worked well for a long time.
It is an Access application which links directly into an Excell table.

Since we installed SP2 for Office 2003, we get the following error:

Run-time error ‘3078’ The Microsoft jet database engine cannot find the input table or query ‘Imported ABC (ruw)”

And the debugger leads us to the following failing command:

DoCmd.RunSQL “SELECT * INTO [Imported ABC (ruw)] FROM [Imported ABC MND3 (ruw)];”

I don’t think it is the sintax or the code, because it worked for several years every week…

Thanks a lot for any suggestion

Luke

Source:

http://microsoft.wmlcloud.com/forums/t/133730.aspx

If you are also dealing with such an issue in your Access database just like the case mentioned in the above practical scenario. Then just go down to this post and grab complete information about this Runtime Error 3078.

About Runtime Error 3078: Can’t Find The Input Table Or Query

Meanwhile the working of Access, you all must have come across various kinds of errors like Microsoft jet database error 3078, Microsoft Office Access can’t find the object, “Unrecognized database format myfile.mdb”, “Microsoft Jet Engine cannot open this file” and so on.

Well, the runtime error 3078 happens when Microsoft Access fails or crashes while it’s running.  This doesn’t mean that the code is corrupt in some way, but just that it won’t work during its run-time. This type of error will appear as an annoying notification on your screen unless it gets fixed. Here are its symptoms, causes, and ways to troubleshoot Access Runtime Error 3078.

Error Information

Name: The Microsoft Office Access database engine cannot find the input table or query ‘|’
Code: Error 3078
Description: 

The above error shows that the Microsoft Office Access database engine is unable to find the input table or query ‘|’. So make sure it exists and whether it’s correctly spelled or not.
Software: Microsoft Access

Screenshot Of The Error:

Before proceeding towards the fixes, catch complete information about this specific Access runtime error 3078 cannot find input table.

Circumstances Under Which Access Runtime Error 3078 Occurs

When someone opens or make a reference to the linked table in Microsoft Access, at that time you may encounter with the following error messages:

Error message 1

• In Microsoft Access 2002
  • Microsoft Access can’t find the object ‘<name>.’
  • Run-time error ‘7874’: Microsoft Access can’t find the object ‘<name>.’
• In Microsoft Office Access 2003, Microsoft Office Access 2007, and Microsoft Office Access 2010
  • Microsoft Office Access can’t find the object ‘<name>.’
  • Run-time error ‘7874’: Microsoft Office Access can’t find the object ‘<name>.’

Error message 2

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

Error message 3

The record source ‘<name>‘ specified on this form or report does not exist.

What Are The Causes Of MS Access Error 3078- Can’t Find The Input Table Or Query?

The main reason behind the occurrence of this error message is when Access can’t find the table or query in the database, if a link points to an external file which doesn’t exist or if that external file is moved to any other location.

 Another very common reason for this error is when the deleted or renamed table or query is referenced on the Lookup tab of any other table.

Resolutions To Fix MS Access Error 3078- Cannot Find Table Or Query

To fix up this error, try the following options mentioned below in this section:

Solution 1# Make sure that the table or query exists, so check for it once. But if in case it won’t exist then you can remove all references to it. Or if it is a missing table, re-import or re-link the table. And if it is a missing query, re-import or re-create the query.

Often, it is seen that RecordSourceproperty of a form or a report contains a reference to a table or query whose name has changed or that has been deleted.

Solution 2# If the query or table exists, then the chances are also that there is a syntax error or spelling error in the references to it. If you found such then correct the syntax or spelling error in the reference.

Solution 3# If you are trying to open the linked table, then the source table may not be in the path that you specified when it was first linked. But if you have moved the file, then you need to make use of the linked table manager to update the link information.

Go With Expert Solution:

If the above error leads to the corruption of your Access Database Table or Query. Then in that case it’s better to make some faster approach for the recovery of your lost Access Database items.

Though there are several methods to repair and fix Access Database corruption like, “Compact and Repair” utility. This inbuilt utility tool creates a backup already and so on.  But it’s not recommended to rely on this utility tool as these techniques work to troubleshoot minor corruption issues arises on your Access Database.  Though there are numerous MS Access errors, with this technique you can resolve only a few of them.

Access repair N recovery software is the ultimate repair tool to rescue when you need an expert solution for major Access database corruption issues. The software is built with an advanced algorithm and is well capable of repairing corrupt MS Access database files of version 2010, 2013, 2016, and older ones too. As the software can easily recover, restore, and repair corrupted/ deleted/lost access ACCDB Or MDB file without effective its originality in any manner.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Final Verdict:

As stated above that it’s not a big deal to encounters errors in Microsoft Access and thus no such need to get panic when you get one. All you need to do is, look for the right method to resolve Microsoft jet database error 3078.  And hopefully, this blog has helped you in getting such.

Besides that, if you get stuck in any data corruption issue then try the Access Repair  N Recovery software for the genuine recovery and resolving essential data from any sort of corruption. The software is also well efficient to resolve the common errors in Microsoft Access.