Have you ever had an intermittent bug, i.e. one that's triggered by some
combination of circumstance, but not another? I don't have the resources or
inclination to try to track this bug down for Microsoft, but it is triggered
only by the interaction of certain conditions, and I don't know what they
are. It could be triggered by anything, even as unobvious as adding the
128th control to a form.
Your Office SP is good. Check that you have SP8 for JET 4 as well. Locate
msjet40.dll (typically in windows\system32), right-click and check on the
Version tab. SP8 is indicated the minor version starting with 8, i.e.:
This is at least as important as the Office SP. In fact, we display this on
the Help | About screen for our clients, using the API calls from:
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.