Access crashes when trying to run specific module

[KeithIT]

I am having a problem with access crashing everytime I try to run, view or edit a specific module in my database. This module has worked for the past few weeks (in fact I am supposed to post the code on this forum for others to use) but all of a sudden (and on a new computer, though one set up the same way as the last) when I try to view the code for the module access crashes and when I try to run the code it crashes. I have not modified the code in any way since it last worked. I'm running access 2002 on a Win 2000 system. Any suggestions? I tried MS Knowledge Base and office support but neither of them were in the least bit helpful, and a general search of this forum and google turned up no helpful responses either. Any help would be greatfully appreciated.

 

[ghudson]

Does your db compile?
Have you repaired/compacted your db?
Have you run the Jet Database Compact Utility on your db?
Have you tried to import all of the db objects into a new db?
Have you tried to export the module into a text file? [Then reimport it]

All of the above suggestions have been previoulsy posted in numerous threads in this forum if you need more info.

You should make a copy of your db before you attempt to "fix" it.

 

[KeithIT]

Still haven't found of those previous posts... I'm probably just searching incorrectly. I tried to compact and repair and used the jet database utility, and it does compile (which is very strange). I deleted it and rewrote the module, which seems to be working now. Not sure what the problem was... but oh well, it works now. Hopefully it was just a fluke... Thanks for the advice.

 

[ghudson]

This one might have saved you from having to recode the module...
Export All Database Objects Into Text Files

When ever a db is acting "weird" it is advisable to import all of the db objects into a brand spanking new db. Any corrupt objects will be identified since Access will not allow you to import a bad object. In your case you knew what was corrupt but the info might help you or somebody else on another day.

 

[KeithIT]

Thanks.