conversion from 95/97 to 2K/2003

[Guest]

My client is in the middle of a large scale migration to Office XP. I work
primarliy with Access files and have noticed something disturbing
happening.... code sitting behind form buttons seems not to be transferring
when the database is converted. I'm not certain it's happening all the time
but it's happening often enough to start looking into it.

Is this a known issue when converting? If so, how do we deal with it? TIA....

J. Freed

 

[Allen Browne]

It is quite common to find that a database is partically corrupt where it
has been modified many times in Access 95 (and to a lesser extent in 97).

A decompile using the old version before conversion will generally fix this
kind of issue. Make a copy of the database, and enter 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"