- Local time
- Yesterday, 21:19
- Joined
- Feb 28, 2001
- Messages
- 27,138
G. - The error log entry that Demax182 posted means it WAS Access that crashed, or more specifically it is ACE that crashed out from under Access, which then means Access is getting dragged down by ACE. It is a memory management violation. There is no doubt this time because the exception code of 0xc0000005 is absolutely unequivocal. That is why I suggested it was a bad install, but the re-install with subsequent failure seems to rule that out, too.
There is one other thing, though. Demax182, when you make the new DB and copy over everything, how many controls do you have on that report?
More specifically, how many controls are in each section and in total of the report? (I'm talking "Design Mode" where the sections are not yet active. Are we talking 5, 50, 500, ... or more?
Do you have any "conditional compile" situations in the report's VBA code?
Do you have any group-by considerations in the report and if so, do any of them involve any kind of functions?
EDIT: I suddenly had a brainstorm. (Or maybe a brain burp.... equal odds with me.) Why is ACE getting involved at all? Has to be that it is trying to validate the recordset underlying the report. What can you tell us about the recordset on which the report is based?
There is one other thing, though. Demax182, when you make the new DB and copy over everything, how many controls do you have on that report?
More specifically, how many controls are in each section and in total of the report? (I'm talking "Design Mode" where the sections are not yet active. Are we talking 5, 50, 500, ... or more?
Do you have any "conditional compile" situations in the report's VBA code?
Do you have any group-by considerations in the report and if so, do any of them involve any kind of functions?
EDIT: I suddenly had a brainstorm. (Or maybe a brain burp.... equal odds with me.) Why is ACE getting involved at all? Has to be that it is trying to validate the recordset underlying the report. What can you tell us about the recordset on which the report is based?