ansaurus

Question

Answer 1

+2 A:

I have experienced that type of behavior in Access 2003, but not yet with 2007.

In those cases I launch the database with the /decompile flag on the end, recompile my VBA code, and exit. Upon return, I've never failed to be back in control of a functional database.

I usually keep a 'Decompile' shortcut in my project folder. Here's the shortcut target:

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "I:\Development\MyDatabase.mdb"  /decompile

David Walker 2009-07-10 18:54:04

Be sure to make a backup before doing this, though to be honest, I've never lost a single line of code from decompiling. Of course, I compile my code so often that it's almost impossible for the compiled p-code to get out of synch with the canonical VBA code.

David-W-Fenton 2009-07-11 01:42:12

I did once have a problem with the MDB after doing a decompile. Like you though I always made a backup.

Tony Toews 2009-07-11 05:54:03

Answer 2

A:

If decompiling doesn't work then try importing all the objects into a new MDB.

We also recommend occasional decompiling. For example if it hasn'tbeen done for quite a while startup times can increase substantially.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times

Tony Toews 2009-07-11 05:56:08

ansaurus

tags:

views:

answers:

Can't create blank form in MS Access

related questions