Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP app with MS Access Database?
Message
De
03/05/2011 10:44:16
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01509216
Message ID:
01509225
Vues:
78
>Hi all!
>
>Anyone ever try doing this over an ODBC (or other) bridge? Have a potential need to have a VFP front-end application, but have its data stored in an MS Access database. Any thoughts?

It's feasible, if you must, and if all the tables you need to write to have proper primary keys. I guess you don't have much choice, or you wouldn't ask.

Watch for fields which have irregular names - containing spaces or other impossible characters, beginning with a digit etc. If you build views using some utility, you may want to replace the Fox-side names with something more meaningful than what the wizard would create.

Also (and I did it only twice, years ago, and briefly), make sure your connectstring contains the full path in the database=[path]; entry. It is not properly stored in the dbc with the connection; you're better off storing or building the connectstring outside of the dbc, and then connecting your views (or SPTs) via the handle.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform