R
Rick Brandt
Allen said:If you develop for others, you probably have multiple versions of
Access installed so you can edit and create MDEs for clients in
different versions. This works fine under Windows XP, even with
Access 2007 installed.
It does *not* work under Windows Vista Ultimate. After running Access
2007, when you open an earlier version of Access, no code works,
because the references are fouled up. And Access 97 does not work at
all.
Access should adapt the Access library according to the version of
Access you are using. Under Vista, this doesn't happen, so Access
2003, 2002, or 2000 attempt to use the Microsoft Access 12.0 library.
Naturally enough, that fails. You cannot just uncheck the bad library
and choose the correct one, since it is a required library.
You can "repair" your Access install, which works until you run
Access 2007 again. Office already does a lengthy reinstallation
whenever you switch versions, so this is not a practical solution.
I've experienced this on Vista Ultimate, and the same was true of the
user who raised this in microsoft.public.access.formscoding. In
cannot say if it applies to other versions of Vista, but since the
problem appears be be the interaction between Office and the Vista
registry, I don't see a reason why it would be limited to Ultimate.
If there does turn out to be a simple solution for this, hopefully we
will hear soon. In the mean time, stay with Win XP if you use
multiple versions of Access.
Thanks for the heads-up Allen. Just to clarify though...are you saying that
even if Access 97 is the only version installed it will not work under Vista or
just that it cannot be repaired after running Access 2007 like the others can?