Cannot open module, Access hangs

[mc]

I am hoping someone can help me with this problem. For some reason, I cannot
open any of my modules, I have to close the database abnormally (end task).
I am able to open my tables, forms, queries etc. I have a front & back end.
I also did a compact & repair before attempting to open the module. Same
problem.

I did make some modifications to the Switchboard form earlier this week.
The users wanted to have sub menus instead of having all the options on the
Switchboard. Basically, they wanted me to group several options together.
So I built 3 other forms similar to Switchboard but changed these forms
accordingly to look at other Switchboard tables. I didn't open any of my
modules as I didn't have to modify any code here. I was able to compile &
create an mde file. I had no problems accessing the mde file, going into the
sub menus I created.
Now I wanted to look at my coding in my module to make it more efficient. I
can't open the modules, very fustrating. I am getting a backup copy restored
from last week. I hope that I can open the modules in this backup copy.

Does anyone know why this happened?

 

[Paolo]

Hi mc,
I think you're experiencing a massive corruption of the structure of some
portion of your database that the compact & repair cannot handle. You can try
decompiling your database, in this way

path_of_msaccess\msaccess /decompile your_database_name
you can read at this URL the pros & cons of decompiling

http://www.trigeminal.com/usenet/usenet004.asp

HTH Paolo

 

[mc]

Thanks, I'll give this a try.

Hi mc,
I think you're experiencing a massive corruption of the structure of some
portion of your database that the compact & repair cannot handle. You can try
decompiling your database, in this way

path_of_msaccess\msaccess /decompile your_database_name
you can read at this URL the pros & cons of decompiling

http://www.trigeminal.com/usenet/usenet004.asp

HTH Paolo