MS Access 2002 is periodically locking (on certain features) or competely hanging up. I've seen other mentions of this on the net, but haven't found any solutions yet.
I am using Access to write an Access project, connected to SQL Server 2000 MSDE, on XP Home. Uninstalling and reinstalling Access and SQL Server helped for a while, but the error frequency is picking up again.
I have not written any VBA or done anything fancy - just tables, views, and forms.
My error log is:
1) Hanging application MSACCESS.EXE, version 10.0.6771.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.
2)Fault bucket 221811522.
I tried repairing MS Office (including Access), and reinstalling, then a complete uninstall/reinstall. The latter significantly helped for a time. SQL Server is making extensive log notes accessible by XP's "Event Viewer", but none of them are errors.