Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 295213 - Last Review: September 27, 2006 - Revision: 4.4
You cannot edit or delete a record on a data access page
This article was previously published under Q295213
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
On This Page
SYMPTOMS
When you try to edit a record that has an expression on a data access page, you receive the following error message
A value could not be saved into the data source's '<FieldName>' field.
Operation failed with a status of 0.
Discard changed value?
where FieldName is the name of the field that you are editing.
When you try to delete a record, you receive the following error message:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
CAUSE
The expression is evaluated when the underlying recordset is modified. These errors occur if the expression is not valid.
RESOLUTION
When you edit or delete records, make sure that you have valid values in the expression that can be evaluated correctly. For example, if the expression divides by a field value, make sure that the value is not zero.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce the Behavior
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
- Start Microsoft Access, and then open the sample database Northwind.mdb.
- In the Database window, click Pages under Objects, and then click New.
- In the New Data Access Page dialog box, click Design View, and then click OK.
- Right-click and then drag the Products table from the Field List to the unbound section on the page. When you are prompted, click Columnar.
- If the toolbox is not already visible, click Toolbox on the View menu. Add a new text box to the page.
- Right-click the text box, and then click Element Properties.
- On the Data tab, type the following expression in the Control Source property:
=ProductID/UnitPrice
- On the View menu, click Page View.
- Click New on the navigation bar on the page to move to a new record.
- Type TEST in the ProductName field on the page, and then click Save on the navigation bar.
- Type TEST in the QuantityPerUnit field on the page, and then press the TAB key. Note you receive the first error message that is mentioned in the "Symptoms" section of this article.
APPLIES TO
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
| kbprb kberrmsg kbnofix KB295213 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
Gary H
- garyh NOSPAM-AT-NOSPAM peninsuladigital.com
|
Reported as Irrelevant
|
| Written:
12/22/2004 1:16 PM |
|
|
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please