>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.
Not quite sure what you're saying here - have you included your .MDB file in your project, so it's being built into your .APP/.EXE?
I suspect the Jet drivers you're using (OLEDB or ODBC) require the presence of an actual on-disk file; I don't think they can look into an .EXE the same way Fox can.
If this is the case, one trick would be to write out the .MDB to a temporary disk file with something like
STRTOFILE( "MyMDB.MDB", "DrivePath\MyMDB.MDB" )
If all this is not the case, can you do some basic troubleshooting like:
- see if you can USE the view from the command window
- make sure you don't have two different .DBCs with view info, maybe you're trying to use the wrong one due to incorrect PATHing etc.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up