Can't find table

B

Bill

We have numerous database where tables are linked. Users
were suddenly getting error message saying "The Microsoft
Jet Database engine cannot find the input table or
query 'name of table'. make sure it exists and the name is
spelled correctly.

Open any of the affected databases and the table link is
there for all three of the tables in question. Click on
the link and Access displays error message indicating
table is not linked.

Has anyone else seen this issue? Thanks for your
assistance.
 
A

Adrian Tofan

check to see if the Back-end database is still there (or moved on a
different folder) or is those 3 tables haven't been deleted or changed
names.
 
W

Wayne Morgan

If the database that the table is linked to is moved or the permissions on
the directory the other database is in get changed so that it isn't
accessabile, you will get what you are seeing. If it has been moved, you can
use the Linked Table Manager (Tools|Database Utilities|Linked Table Manager)
to relink the tables or you can delete them and create new links yourself.
To do this using code, see the following:

http://www.mvps.org/access/tables/tbl0009.htm
 
Top