How did you "set up a connection to an Access mdb file"?
Anyway, the following works for me:

store SQLSTRINGCONNECT(;
'DBQ=c:\hi1.mdb;'+;
'DefaultDir=c:\;'+;
'Driver={Microsoft Access Driver (*.mdb)}');
TO gnConnHandle

?SQLTABLES(gnConnHandle)
?SQLEXEC(gnConnHandle, "select * from out")
....


>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?