Version Compatibility

[Hafeez]

My Access 2000 database runs well on machines running
Access 2000, however when running on Access 2002 my forms
and macros (based on code) don't work because of
references.
Office 2002 -> 10.0 object library
Office 2000 -> 9.0 object library
I've included references to both Access and Excel.
Neither one is compatible with the other and Access isn't
smart enough to automatically refer to the other when one
is "MISSING:" (and worst of all is that my users panic
when things go wrong).
Is there a fix to this so my users can access all the
functionality of the db in both versions?
Hafeez

 

[Rick Brandt]

My Access 2000 database runs well on machines running
Access 2000, however when running on Access 2002 my forms
and macros (based on code) don't work because of
references.
Office 2002 -> 10.0 object library
Office 2000 -> 9.0 object library
I've included references to both Access and Excel.
Neither one is compatible with the other and Access isn't
smart enough to automatically refer to the other when one
is "MISSING:" (and worst of all is that my users panic
when things go wrong).
Is there a fix to this so my users can access all the
functionality of the db in both versions?
Hafeez

Switch to Late Binding for anything related to Excel. This does not
require setting a reference and (for the most part) will make your code
insensitive to the version of Office installed.

Early binding (with references) simply cannot be used unless you are
absolutely positive that all users have the same references.