ACC97: No Error Message with Delete or Commit on ASP Pages

• Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you try to delete or update a record on an Active Server Page (ASP), the record is not deleted or the change is not made. However, you do not receive an error message letting you know that the deletion or modification failed. If you try to delete or update the same record when the form is open in Microsoft Access 97, you receive an error message letting you know the record could not be deleted or the change could not be made.

CAUSE

Your form is based on a table that is participating in referential integrity, contains required fields, or contains fields with validation rules.

MORE INFORMATION

Records will not be deleted if the table that the record is in is on the one-side of a one-to-many relationship and the many-side table contains related records.

Updates to fields will not be committed if they do not conform to the Required and Validation Rule properties of the table that the form is based on. Updates to fields participating in referential integrity on the one- side of a one-to-many relationship will not be committed if there are related records in the many-side table.

This behavior can also occur if both of the following conditions are true:

• The ASP files are located on a server running a version of Microsoft Personal Web Server that is earlier than 4.0 or a version of Microsoft Internet Information Server that is earlier than 4.0.
• You are trying to update a field with data that is longer than the size of that field. For example, you are trying to enter a 15-character string into a text field whose FieldSize property is set to 10.

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb in Microsoft Access 97.

2. Open the Customers form and try to delete the first record. Note that you receive the following error message:

         The record cannot be deleted or changed because table 'Orders'
         includes related records.
   

3. Click OK to the error message.

4. Save the form as an Active Server Page.

5. Open the newly exported form on your Web browser.

6. Scroll down to the bottom of the form and click Delete.

7. In the "Press OK to delete current record" box, click OK. Record two becomes the current record.

8. Scroll down to the bottom of the page, and select the record selector to return to the previous record. Note that the record you tried to delete still exists.

REFERENCES

For information about permissions necessary for IDC/HTX files, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q160754
   TITLE     : ACC97: Error "HTTP/1.0 403 Access Forbidden" Browsing IDC
               Page