Major Corrruption Issue

  • Thread starter Thread starter Ken Wilkinson
  • Start date Start date
K

Ken Wilkinson

I have a large Access 97 DB that has corruption in the code. Compiling the
code causes it to crash (GPF), sometimes even entering code causes it to
crash. Importing into a new shell doesn't solve the problem. I've been told
by microsoft that I need to remove all the code from the database (forms,
reports and modules), run some cleanup procedures and put it all back. This
database has over 100 of each of these objects. Does anyone know a way of
automating the process of removing code to text files and putting it back?

Thanks
KenW
 
Hi Ken

You could also try the Decompile method as follows:

1. Create a backup copy of the MDB file while Access is not running.

2. Decompile the database by entering something like this at the command
prompt (one line, including the quotes):
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

3. When the database opens: Tools | Database Utilities | Compact.

4. Open any code window, and choose Compile from the Debug menu.
If you get errors, fix them and keep compiling until there are no
errors.

Good luck, and please keep us informed.

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Maurice

I've tried that and the last step (compiling) rather than giving me any
errors just crashes.

Thanks
KenW
DB4DP
 
Back
Top