D
D Riggins
I have a form with a subform and whenever I try to delete a record in the
main form, I get the error "Could not update, currently locked by another
session on this machine". This occurs several times then the record is
finally deleted. Since I know I am othe only one in the DB and there is only
one session going, the error makes no sense.
The records in the subform are in tables that are related to the main form
records with a one-to-one relationship on the primary keys (with referential
integrity enforced and cascade update and delete enabled). The subform
records do not include the table that the main form uses as a datasoruce.
The same thing happens in both Access 2003 and 2007.
Can anyone tell me what the error really means?
main form, I get the error "Could not update, currently locked by another
session on this machine". This occurs several times then the record is
finally deleted. Since I know I am othe only one in the DB and there is only
one session going, the error makes no sense.
The records in the subform are in tables that are related to the main form
records with a one-to-one relationship on the primary keys (with referential
integrity enforced and cascade update and delete enabled). The subform
records do not include the table that the main form uses as a datasoruce.
The same thing happens in both Access 2003 and 2007.
Can anyone tell me what the error really means?