Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC - Access allows numerials to begin fields but VFP d
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00666706
Message ID:
00666987
Vues:
19
This message has been marked as a message which has helped to the initial question of the thread.
Mike,

one more idea (after a cup of coffee <g>):

You could create an Access MDB as some kind of a middle layer that contains one query for each table in the other MDB (you might have to "attach" those tables to your MDB). In the queries you could specify new column names with the "AS" clause, so the names are VFP compatible. Then you could base your VFP views on those queries.

Maybe renaming the columns is already possible in the attached tables, so you get around the additional queries. But I don't really remember, if that's possible.

BTW: Attaching tables and building the queries could be done automatically by writing some lines of Code in the MDB.

Armin

Armin Neudert
Regional Director (Stuttgart) of German FoxPro User Group dFPUG

MCP for Visual FoxPro

Expert/Editor of the VFP section in the German Codezone community portal
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform