M
Mike in Triangle NC
Starting in August 2003, I began to get this error message for a
database that I built, and that had been reliably in use for 2.5
years. I only had this problem on new PCs where I applied all of the
critical Windows updates along with the recommended updates *in a
single pass*. If I applied any updates relevant to Access, Jet, MDAC,
and dao sequentially (any sequence), I didn't have these problems.
These updates included Win2k sp4 and Jet Sp7. This occurred for both
Windows 2000 and Windows XP machines.
I found 2 solutions:
1) rebuild the machines where I had updated in one pass, and update
sequentially.
2) I rebuilt the form that was having problems. The error occurred
under the following conditions:
a) the form had been opened via code behind a main menu button.
b) subform code had been called, because there were subform "On Enter"
procedures.
c) the subform code included running an delete query on the data
underlying the subform.
d) the procedure that opened the main form had a .requery call.
I replaced the delete query with a dao recordset procedure, and the
problem went away.
The only conclusion I could reach was that there wasn't anything
fundamentally wrong with my code, but that the updates to Jet/Dao had
loaded improperly when loaded in one pass. I was never able to
isolate any difference in driver files or the registry.
I hope this helps someone else.
database that I built, and that had been reliably in use for 2.5
years. I only had this problem on new PCs where I applied all of the
critical Windows updates along with the recommended updates *in a
single pass*. If I applied any updates relevant to Access, Jet, MDAC,
and dao sequentially (any sequence), I didn't have these problems.
These updates included Win2k sp4 and Jet Sp7. This occurred for both
Windows 2000 and Windows XP machines.
I found 2 solutions:
1) rebuild the machines where I had updated in one pass, and update
sequentially.
2) I rebuilt the form that was having problems. The error occurred
under the following conditions:
a) the form had been opened via code behind a main menu button.
b) subform code had been called, because there were subform "On Enter"
procedures.
c) the subform code included running an delete query on the data
underlying the subform.
d) the procedure that opened the main form had a .requery call.
I replaced the delete query with a dao recordset procedure, and the
problem went away.
The only conclusion I could reach was that there wasn't anything
fundamentally wrong with my code, but that the updates to Jet/Dao had
loaded improperly when loaded in one pass. I was never able to
isolate any difference in driver files or the registry.
I hope this helps someone else.