Access 2002 vs. 2003

[Doug Leveille]

I recently upgraded my version of Access from 2002 to
2003 for development. After working on an .adp file and
creating an .ade file, the users were unable to use the
program with Access 2002 runtime. Is this because the
adp reference was changed to Microsoft Access 11.0 Object
Library? If so, is there a way around this or must I
continue to develop with Access 2002? Even when I create
a brand new .mdb file on my computer using Access 2002,
the reference is still set to the 11.0 Object Library
instead of the 10.0 Object Library.
Thanks

 

[Paul Overway]

It is because the file formats are not compatible. You cannot use a 2003
file in prior versions unless it is in 2000 format. You cannot create a ade
file unless the adp is 2003. So, you need to go back to 2002 version or
your users need to upgrade. And the reference problem is because you have 2
versions installed and you're using the new Object Library....this will also
prevent your users from being able to open the file.

For any Jet 4.0 database, develop on the lowest version of Access your
target audience has....that way, you avoid these problems.