Using Windows XP SP-1 with all security udpates installed
MS Access version 10.2627.3501 SP-1 (all service packs to be installed over
the weekend)
MDAC 2.8
Jet 4.0 SP 8
When the database and access are closed, the MSACCESS.EXE process is left
running and will not allow another instance of Access to be opened until the
original process has been terminated.
I have determined that the cause of this is from a calculated field on a
subform set to display as continuos form. I have only found one other
mention of this in comp.databases.ms-access and there was no work around
provided. I would prefer to keep the calculated field on the subform. Is
the only way around this to code in the calculation into the forms OnCurrent
event, or is there another way that I have not thought of yet? Will one of
the service packs cure this? Is this such an isolated occurance that I am
likely to be one of two people in the world who has this problem?
Thanks for any help you can provide,
Mike