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?