VBA used in Access XP not working in Access 97

J

John

How can I integrate using Access XP VBA into being accepted by Access 97?
Some people work in XP others are still in "97".
 
L

Larry Linson

John said:
How can I integrate using Access XP VBA into being accepted by Access 97?
Some people work in XP others are still in "97".
Click to expand...

I am not sure I understand the question.

You can save an Access 2002 database "as previous version" in Access 97 file
format. New features added to Access since Access 97 will, as you might
expect, not work for Access 97 users.

On the database window menu, Tools | Database Utilities | Convert Database |
To Access 97... should save it for you. You'll have to find any "new
features" -- many can be replaced with VBA code that performs the same
function. For example, there are many people's versions of a Replace
function archived at groups-google in the comp.databases.ms-access newsgroup
archives if you have used the now-built-in Replace.

Larry Linson
Microsoft
 
D

David C. Holley

Anytime you're developing across multiple versions, its always best to
develop using the older version to ensure compatibility. I can't answer
the question other than to say that anytime a new version is released
inevitibly(sp?) there changes, sometimes major sometimes minor, that are
not backward compatibile.

David H
 
Top