Çould not find file - error

V

Vivek

I am running this simple query to load the Manufacturer table from Inputs
table.

INSERT INTO Manufacturer.[(Manufacturer Name)]
SELECT Inputs.Manufacturer AS Manufacturer
FROM Inputs;

but I am getting a message, 'Çould not find file 'pathname\Manufacturer.mdb'

Where should I go and change the path name?
 
J

Jerry Whittle

Assuming that Manufacturer is a linked table and you have Access 2003 or
older, go to Tools, Database Utilities, Linked Table Manager and relink to
the proper database file.
 
Top