Is there any way to get Access to display what the problem is?
Doubtful, since this is likely a GPF (General Protection Fault).
Try opening Access with the optional /decompile switch. If you have only one
version of Access installed on your PC, you can click on Start | Run and
enter:
msaccess /decompile
Browse to the affected database. Hold the Shift key down the entire time
that it is opening, to prevent any startup code from running. Do a Compact
and Repair operation first thing, again while holding down the Shift key the
entire time. Then open any code module and do a Debug | Compile {ProjectName}.
The /decompile option removes any compiled "P" code from your database,
which may be corrupted. Compacting clears out any left over garbage.
Recompiling produces a new copy of the compiled "P" code. (The compiled "P"
code is not the same human-readable ASCII text version of the code that you
can see and edit).
Please feel free to donate the small fee of your choice to the Northwest
Kidney Center in Seattle.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________