E
Eric Sambell
Hello,
I have been having a problem with a form of mine with several layers of
sub-forms in Access 2007 SP1. When I delete a record from the lowest level of
sub-form it disappears from the list as normal, but then when I go to move to
another record, or do pretty much anything else Access throws an "operation
not supported in transactions" error. As well the record doesn't actually get
deleted. All of the sub-forms are in datasheet view, and so they appear as if
they are several layers of sub-datasheets. Also the base tables are linked
from a seperate backend .mdb file. I get a very similar result when I do a
"paste append."
I assume that Access is opening a transaction to delete (or "paste append")
but not completing it. Does anyone know of a fix or a way to force Access to
complete the transaction?
Thanks,
Eric Sambell
I have been having a problem with a form of mine with several layers of
sub-forms in Access 2007 SP1. When I delete a record from the lowest level of
sub-form it disappears from the list as normal, but then when I go to move to
another record, or do pretty much anything else Access throws an "operation
not supported in transactions" error. As well the record doesn't actually get
deleted. All of the sub-forms are in datasheet view, and so they appear as if
they are several layers of sub-datasheets. Also the base tables are linked
from a seperate backend .mdb file. I get a very similar result when I do a
"paste append."
I assume that Access is opening a transaction to delete (or "paste append")
but not completing it. Does anyone know of a fix or a way to force Access to
complete the transaction?
Thanks,
Eric Sambell