Has anyone else experienced problems with 2002 databases keep closing down and corrupting? I have created a brand new DB but it keeps closing down and now it is corrupted beyond repair. I've tried re-importing tables etc into a blank database but it won't import the modules etc as it says the vba code is corrupt. I'm starting to hate v2002, I didnt seem to get these problems in v97!
Have your tried the free Microsoft Jet Compact utility? Click on the link below for the version of Access you are using. For more details, search the Microsoft Knowledgebase for Jet Compact. I have had a lot of success using Jet Compact to repair a db when I thought it was corrupted and Access could not repair itself.