Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view Access2003 table Resrvd Wrd used field name
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Remote view Access2003 table Resrvd Wrd used field name
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Jet/Access Engine
Divers
Thread ID:
01055294
Message ID:
01055294
Vues:
73
Hi All,

I have bled for about 3 hours today on this one. I have a remote view into an Access2003 Database. The table that I am accessing has 2 fields that are reserved key words in VFP. The fields are id and number. I cannot rename the fields in Access because another program is accessing the table.

I can view the records in the Remote view but I can't update them because of the field name issue.

Is there a work-around to update the table through the remote view?

Thank you,
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform