How do you fix database conversion errors?

[Guest]

After converting a database from Access 2000 to Access-97, I get "The
expression AfterUpdate you entered as the event property setting produced the
follow error", followed by a general discription of an error in a macro,
procedure, or event property. I am not able to reach a breakpoint in the
AfterUpdate event property code either. The Access 2000 code performs
without error.

 

[Allen Browne]

If this has always happened since you converted, then the problem may be in
Access 2000. If so, you need to fix the problem there, and convert again. A
decompile sounds like the way to start.

1. Turn off the Name AutoCorrect boxes under:
Tools | Options | General.

2. Compact the database:
Tools | Database Utilities | Compact

3. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

5. Convert to A97.

6. Open the A97 database. Open the Immediate window (Ctrl+G). Check your
references:
Tools | References.
More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

More suggestions on recovering from corruption:
http://members.iinet.net.au/~allenbrowne/ser-47.html