R
RipperT
I have a form/subform/subsubform (3 nested) arrangement that is based on
three tables with one to many relationships and cascading deletes. Until now
I've had no problems deleting records, but now for some reason, I get the
following error when trying to delete a record in the main form:
could not update; currently locked by another session on this machine
But I know of no other sessions that are open on this machine.
If I click OK, the message reappears. Click OK again and then it allows me
delete the record with the standard message about cascading deletes. After
the delete, the next record is visible, but the fields in the subform all
show #deleted#. If I then try to navigate away from the main record, another
error message says "Record is deleted." Click OK and a run time error occurs
because the subforms OnCurrent code tries to set a field value. Run time
error says: "Record in tblCharges (subform) was deleted by another user."
It's as though Access is deleting the subform records from a different main
record than the one I am deleting. If there are no records in the subform
for the record in the main form, there are no errors when deleting the main
record.
I copied the production backend to my developement location, compacted,
repaired and relinked the tables in the front end (in case some
relationships got screwy or something), but no change, except now I've also
gotten this message upon deleting:
operation not supported in transactions
How can I get back my cascading deletes?
Thanks,
Ripper
three tables with one to many relationships and cascading deletes. Until now
I've had no problems deleting records, but now for some reason, I get the
following error when trying to delete a record in the main form:
could not update; currently locked by another session on this machine
But I know of no other sessions that are open on this machine.
If I click OK, the message reappears. Click OK again and then it allows me
delete the record with the standard message about cascading deletes. After
the delete, the next record is visible, but the fields in the subform all
show #deleted#. If I then try to navigate away from the main record, another
error message says "Record is deleted." Click OK and a run time error occurs
because the subforms OnCurrent code tries to set a field value. Run time
error says: "Record in tblCharges (subform) was deleted by another user."
It's as though Access is deleting the subform records from a different main
record than the one I am deleting. If there are no records in the subform
for the record in the main form, there are no errors when deleting the main
record.
I copied the production backend to my developement location, compacted,
repaired and relinked the tables in the front end (in case some
relationships got screwy or something), but no change, except now I've also
gotten this message upon deleting:
operation not supported in transactions
How can I get back my cascading deletes?
Thanks,
Ripper