>I set up a connection to an Access mdb file and created a remote view using one of the tables in the database. Whenever I attempt to use the view, a Select Database dialog appears asking for the .mdb file to use.
>
>How can I get this to be automatic so that the user does not get this dialog?

How you connect to Access MDB?
Via CONNECTION or DSN?

CREATE DATABASE TEST
OPEN DATABASE Test
SET DATABASE TO Test

CREATE CONNECTION MyAccess CONNSTRING  "Driver={Microsoft Access Driver (*.mdb)};Dbq=FULLPATHTOACCESSDB.mdb;Uid=USERNAME;Pwd=PASSWORD;"

CREATE SQL VIEW MyView CONNECTION MyAccess AS SELECT * FROM AccessTable