I've been working with an Access 97 application, through various
versions, for 10 years. This application runs asan mde in runtime mode
on hundreds of PCs around the globe.

About a week ago I started getting frequent corruption in the front
end mdb, followed by compile errors for DAO 3.51 declarations, on my
development PC.

My app starts using a CheckReferences routine, written, I think, by
the Harbin bros. I've been using this routine in this application
since 1999. DAO is still there and the reference is intact.

I import everything into a new database and recompile using /decompile
and the problem goes away ... for a bit.

I have reinstalled Acc97 + SR2. Problem keeps coming back. Any clues?

Thanks

Jennifer

It may have something to do with computers moving from WindowsVista to
WindowsXP. To check references you generally need to use the ADOX
reference. WindowsVista keeps changing the reference to a newer version.
When the front end is brought back to WindowsXP, the reference is corrupt.

Other than that, it's amazing Access97 still works. That's pretty cool

Dom


"Jennifer" <MXRoute (AT) gmail (DOT) com> wrote

On Feb 28, 1:02*pm, "Dominic Vella" <dominic.ve... (AT) optusnet (DOT) com.au>
wrote:
Hello Dominic

Thank you or your input. The runtime version runs happily on both XP
and Vista (thanks to sagekey.com). The development version, where I
have the problem, is only on XP.

Jen

On Feb 28, 1:03*pm, Jennifer <MXRo... (AT) gmail (DOT) com> wrote:
Just in case this is of any use to anyone, the problem is fixed ...
the CheckReferences routine has to be called from autoexec to be
effective. I recently moved it so that it was called from a module.
Once I put it back, the corruption problems went away.

Jen