Access databse error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I attempt to open any of my Access 2003 databases (table, query or form)
I get the following error:

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
3078)
Possible causes:
• The specified table or query does not exist.
• You misspelled the table or query name. Check for missing underscores ( _
) or other punctuation, and make sure you did not enter leading spaces

These databases and their paths are valid and were accessable until
recently. Any ideas? Thanks!
 
Are you receiving this error when opening any databases, or objects within a database (tables,
queries, forms) once you have the database opened. If you receive this error when opening a
database, try holding down the shift key while opening it. One cause (there are many) for this
error is discussed in this KB article:

Error message: "Couldn't find input table or query '<name>'"
http://support.microsoft.com/?id=287696

This can happen when a linked table does not point to the correct path. If a query or form
depends on the linked table, the error will show up when you attempt to open the query or form.
Try opening a local table versus a linked table in a database that is showing this problem. A
linked table should have a small black arrow pointing towards the name of the table. If a local
table opens fine, but a linked table produces the error, this is further evidence that the path
is incorrect to the linked table.

Here is another possible cause:

You receive error messages when you convert the workgroup information (.mdw) file in Access 2003
http://support.microsoft.com/kb/824258


Tom
_______________________________


When I attempt to open any of my Access 2003 databases (table, query or form)
I get the following error:

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
3078)
Possible causes:
• The specified table or query does not exist.
• You misspelled the table or query name. Check for missing underscores ( _
) or other punctuation, and make sure you did not enter leading spaces

These databases and their paths are valid and were accessable until
recently. Any ideas? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top