Access databse error

D

Donny Blues

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!
 
T

Tom Wickerath

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!
 
Top