I am trying to get my Form to load with the Remote View but it keeps prompting me with a look up dialog box to find the MS ACCESS Database. The remote view is already set up with a connection to the MS Access Database, yet it is as if the form can't figure this out, so I have to manually keep looking for the same MDB file each time.

Obviously this won't work in a programmatical way. Not to many users are going to know where to locate the MDB file which is already a part of the Project through a remote view.