Access 97 VBA Problem with Windows 2000
I too have recently started running Access97 under Win2k.
Prior to Win2k deployment, our folks did some "upgrade
Windows, don't upgrade Office" compatibility testing and
found some Access97 functions were not supported in Win2k.
This function problem happens on a hit or miss basis, with
little info anywhere about how to solve directly (typical
solution is to write new replacement code). Some things
affected include exports to Excel in VBA, building forms in
VBA, and reformatting dates in VBA. So, you may see failure
when trying to run an unsupported function but not
otherwise.
In my case, I had some unsupported date formatting crop up
that worked under Win95. The solution was under
Tools|References, item "Microsoft Visual Basic for
Applications Extensibility 5.3."
I suspect these other items are available to me due to
having Office2k now versus Office97 before. If you don't
have Office2k, you may have some recoding ahead.
-Patrick
Quote:
>-----Original Message-----
>Several times when I've been running VBA code in Access 97
under Windows
>2000, I get a very polite message saying that Access has
encountered an
>error and will close--which it does, usually leaving me
with unsaved
>changes. It's happened on two different machines. Access
97 has never done
>that to me on Windows 95 or 98. I couldn't find anything
in the Knowledge
>Base on this problem.
>.
