Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01205044
Message ID:
01205126
Vues:
23
>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" )
* I understand STRTOFILE() will find the file in the .EXE
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform