unable to delete record

[Seasider]

I am very puzzled and have tried every possible way I can think of to troubleshoot this problem but have failed.

I have a table that contains contact information. The data is entered through a form called frmContacts. The primary key field is ContactID and it is an autonumber type field. The problem is that I an not able to delete any records through the form.

I have tried deleting records by using the main menu, File, delete record. The message box pops up and asks me to confirm if I want to delete the record. I say "yes" but the record does not delete. It is still there even when I close the form and reopen it. I even added a delete command button to the form but that made no difference.

I have searched through lots of threads but found no similar problems there. Hope some has a suggestion.

Thanks.
Seasider

 

[Seasider]

unable to delete records from form

By the way, I AM able to delete records directly at table level. It is only when using the form that I am not able to delete them. In the properties Allow Deletions is set to "yes".

Seasider

 

[reggibson]

Unable to delete

I had a similar problem some while ago. My case was using an SQL server database. The ODBC layer had a bug that allowed to report back success on the delete even though the backing database failed on the delete due to referential integrity constraints.

I do not remember any more details but I hope this may help.

 

[Pat Hartman]

Is your form based on a query? Can you delete records with the query? If the query is a 1-m relationship, you can't delete the 1-side record with this query. You can only delete the many-side records. Also, if you have RI enforced but do not allow cascade delete, Access won't let you delete a 1-side record if there are any many-side records.