Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Design question regarding possibilities with ADO
Message
 
À
24/01/2001 11:11:46
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00467907
Message ID:
00468023
Vues:
19
>Hi,
>
>I'm using an adodc data control (retrieving data from Access) that's binded to a datagrid object.
>
>The data control has 7 columns but only 2 that are populated. The rest of the columns could be populated by the user. These columns would be populated through a series of textboxes giving choices to users according to each column.
>
>I thought that the following command would edit a row of the recordset (that is, the user scrolls through the grid positionning cursor on the appropriate record):
>Adodc1.Recordset("Region").Value = "East"
>
>But I get the following error (translated from french):
>A multi-steps operation generated errors. Verify each status value: #2147217887.
>
>What should I look at?
>Can I edit (and even add record) column in and adodc recordset?
>
>TIA.

Possibly MS Access table refused to save the data, because it breaks data validation rules.
You may check AllowZeroLength property of text fields in your table, if it set to "No" make sure that you provided valid data, but not "".

HTH, Igor
Igor Gelin
Database Developer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform