>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only