I am migrating an existing Access 2003 db to 2007. I have a form with a subform. The form is normally expressed as a datasheet. There is no vba code or macros associated with these forms; they are a simple form/subform combination.
When I delete a record from the subform, I'm not warned about the deletion but the record appears to be deleted. When I move to another record on the form and attempt to open the subform (by clicking on the + field), I get the error "Operation not supported in transaction" and the original record that appeared to have been deleted re-appears.
This process works fine in 2003.
Any thoughts? Microsoft doesn't give any clue as to how to end an Access-initiated (vs VBA-initiated) transactions.
Thanks,
Alan Miller
CPD
Programmer Anaylyst
SMCCCD
When I delete a record from the subform, I'm not warned about the deletion but the record appears to be deleted. When I move to another record on the form and attempt to open the subform (by clicking on the + field), I get the error "Operation not supported in transaction" and the original record that appeared to have been deleted re-appears.
This process works fine in 2003.
Any thoughts? Microsoft doesn't give any clue as to how to end an Access-initiated (vs VBA-initiated) transactions.
Thanks,
Alan Miller
CPD
Programmer Anaylyst
SMCCCD