I need to read (only) several tables from an .MDB file. I've added remote views to my .DBC and used the Access ODBC driver in the named Connection.

Whenever I attempt to reference the remote view name (i.e. Select * from ) a prompt appears asking me to locate the .MDB.

Is there a way to build the location of the .MDB into the view/connection/database definition so that the prompt doesn't appear ?
Thanks !
Cliff