I was working on designing the db yesterday and somehow it appears that the code behind the windows/object of the application has gotten corrupted.
The reason I suspect this is that anytime I try to open anything with code behind it I get the dreaded "MSAccess has encountered a problem and needs to close error"
I tried to open the module and do a compile on it (this usually shows where the error is) but when I try to open the module I get the same result!
If you know how to get into this file without it blowing up please let me know!
I have tried do a Compact and Repair - no help there!
Further investigation shows that it is a particular window that is corrupted - I have been able to recreate everything in the database by creating a new one and importing everything BUT the window in question. Is there some way to edit the code that is in that window?