Enter Password for Select in

[InFlight]

I have written a database for bird shows. I need to see what data is changed in a table. in a query from a different database. I have this SQL

SELECT Exhibitors.* FROM Exhibitors IN 'M:\InFlight\Data\BirdShowData.accdb';

When i view it in design view it asks for the password which i enter then i can view the query in design view. When i run the query it tells me the password is incorrect.
Any Ideas
I not want to use a linked table yet.

 

[Ranman256]

Use a linked table.
THATS WHAT THEY'RE FOR.

 

[InFlight]

Great Answer