Enter Password for Select in (1 Viewer)

InFlight

User
Local time
Tomorrow, 03:27
Joined
Jun 11, 2015
Messages
130
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

Well-known member
Local time
Today, 10:27
Joined
Apr 9, 2015
Messages
4,339
Use a linked table.
THATS WHAT THEY'RE FOR.
 

InFlight

User
Local time
Tomorrow, 03:27
Joined
Jun 11, 2015
Messages
130
Great Answer
 

Users who are viewing this thread

Top Bottom