Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't update a memo field in a Access 97 .mdb
Message
From
20/11/2000 05:22:40
Dino Liberale
Ministero Lavori Pubblici
Trieste, Italy
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can't update a memo field in a Access 97 .mdb
Miscellaneous
Thread ID:
00443562
Message ID:
00443562
Views:
34
I have an MS Access 97 DB, by a connection and a remote view i can browse data, but when i try to update a memo field it generate these errors, retrived by AERROR(aErr) function :

aErr(1,1)=1526 (n. ref. of a connectivity error)
aErr(1,2)="Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement."
aErr(1,3)="[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement."
aErr(1,4)="37000"
aErr(1,5)=-3503
aErr(1,6)=1
aErr(1,6)=.NULL.

Wy I am able to update all fields, but not the memo ?

T.I.A.

Dino
Reply
Map
View

Click here to load this message in the networking platform