Decompile Issue

[Guest]

Upon reading Allen Browne's comments on converting Access 97 to Access 2003
(http://allenbrowne.com/ser-48.html), I attempted to decompile a database. I
received the following series of messages:

"Save operation failed", "File not found", "The expression On Open you
entered as the event property setting produced the following error: file not
found -- the expresson may not result in the name of a macro -- there may
have been an error evaluating the function, event, or macro"

Naturally, I looked through all forms and reports I have to check out any On
Open events that were set -- none open an unknown file, function or macro. I
looked through my macros to see if there was anything suspicious there --
and, I checked my modules for any function that may have opened a file --
nothing...

I was able to convert my database successfully to 2003 anyway (well, MS says
it was successful) -- I have tested functionality and all looks ok so far --
I have all of the services packs installed (except XP svcpk 2), just as
suggested...

does anyone know what may have caused this? this is the 4th database that i
have converted from 97 to 2003 -- I had no problems with the others at all
(only this one); also, should I even worry about this since the conversion
appears to be alright? (i haven't extensively test the database yet) -- p.s.
this is just an FE app (SQL server 6.5 as BE)

thanks
kat

 

[Allen Browne]

If you were subsequently able to convert the database without a problem,
then you are probably fine.

Sounds like you are able to open the code window in the new file?

Choose References from the File menu. There should be just a few (typically
3 - 6) checked. Make sure none of these are marked "MISSING".

Then choose Compile from the Debug menu. If it compiles correctly (or if the
Debug option is dimmed indicating it is already compiled), then A2003 is
making sense of all the code, so things look pretty good.

There is still the chance that some corrupted module was completely dropped
in the transfer. If so, you would have a form (or report) that has no code
at all, and you would discover that fairly quickly.

 

[Pieter Wijnen]

Hi Allen,
I Suspect she forgot to hold down the SHIFT key during the process..

Pieter