rthomsen
asked on
Access Crashing When View Code
Hi
I have an Access 97 Application and 1 of my forms seems to have become corrupted. I can view the code module of all of the other forms but when I try to the view the code of the problem form, the application quits. I tried to import the form into another DB and it won't do that either. Any ideas?
Thanks
rthomsen
I have an Access 97 Application and 1 of my forms seems to have become corrupted. I can view the code module of all of the other forms but when I try to the view the code of the problem form, the application quits. I tried to import the form into another DB and it won't do that either. Any ideas?
Thanks
rthomsen
ASKER
Any idea how this may have occurred?
This is something Access developers get used to and plan for by maintaining a vigorous backup agenda.
I periodically (daily or better during development) import all Forms/Reports/Modules to a separate backup to keep the coded object backup.
A full backup is done regularly
During developement periods,...CRSCRSCRSCRS
(compact repair SAVE compact repair SAVE compact repair SAVE compact repair SAVE)
The heavier I'm hammering code and object, the move often I run the backups.
I periodically (daily or better during development) import all Forms/Reports/Modules to a separate backup to keep the coded object backup.
A full backup is done regularly
During developement periods,...CRSCRSCRSCRS
(compact repair SAVE compact repair SAVE compact repair SAVE compact repair SAVE)
The heavier I'm hammering code and object, the move often I run the backups.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok...this is the weirdest thing ever.
Every time I clicked the code menu button or view->Code in the access menu, access would crash.
But...I right clicked on the form and selected Build Event.... and chose the Code Builder and I was able to gain access to the code and now everything seems to be fine. I saved and did a compact and repair and now I'm going to create a backup.
Thanks for your suggestions.
rthomsen
Every time I clicked the code menu button or view->Code in the access menu, access would crash.
But...I right clicked on the form and selected Build Event.... and chose the Code Builder and I was able to gain access to the code and now everything seems to be fine. I saved and did a compact and repair and now I'm going to create a backup.
Thanks for your suggestions.
rthomsen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Even though It worked itself out, I just split the points between everyone who attempted to help.
Thanks
rthomsen
Thanks
rthomsen
But we let you know you are not alone in the world of database corruption!
I hope we all still provided a little extra to think about for the next occurrance.
thanx for the question!
I hope we all still provided a little extra to think about for the next occurrance.
thanx for the question!
I hope you have an older copy of the form in a backup mdb. It appears it is hopelessly corrupted.
regards
Jack