Çould not find file - error

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?

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Vivek" wrote:

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?