Incompatibility between Access 97 and Office XP

[Martin]

Does anyone know if there are any known incompatibilities
between Access 97 and Windows XP Professional? Our
organization recently upgraded OSs from 97 to XP Prof,
however chose to keep Access 97. I've been having weird
issues that are inexplicable--ie. errors when running VBA
apps that weren't a problem before the upgrade.

Any help is appreciated. I've tried other forums and
haven't gotten any responses.

Thanks a bunch!

 

[Martin]

Sorry, I meant NT to XP Professional, not 97 to XP...

 

[GVaught]

Whenever you move to a new OS or even a new version of Access, you need to
make sure the references that were set with the old OS/Access are set on the
new OS. Open the database and issue a compile against the database. If there
is a reference missing, Access will point to a section of code that is
failing.

 

[martin]

thanks a lot for your advise.

-----Original Message-----
Whenever you move to a new OS or even a new version of Access, you need to
make sure the references that were set with the old OS/Access are set on the
new OS. Open the database and issue a compile against the database. If there
is a reference missing, Access will point to a section of code that is
failing.

--
G Vaught




.

 

[Tony Toews]

Does anyone know if there are any known incompatibilities
between Access 97 and Windows XP Professional?

No, been working fine for me. And I have A97, A2000, A2002 and A2003
installed.

Our
organization recently upgraded OSs from 97 to XP Prof,
however chose to keep Access 97. I've been having weird
issues that are inexplicable--ie. errors when running VBA
apps that weren't a problem before the upgrade.

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones, delete
from the references list and Compile and Save All. Keep any
necessary references and ensure they are distributed to the target
system.

For a very detailed page on reference problems see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

The Access 97 default references are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5x Object Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm