>>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
>
>I've had better luck specifying the Access MDB in the ODBC DSN. But every now and then I still get prompted. I think it's MS's Access driver...
>
>-Mike

Mike, thanks for the reply. I've never used the DSN - what's the syntax ?
Thanks !
Cliff