Hi,
I want to work with Access 2002.
I will need to be able to distribute my application to users that may
still have access 2000 on their computers. I know access 2002 has a
function that enables you to convert a database to a format of an
earlier version of Access. I wanted to check for any unforeseen
problems so here is what I did:
I used Access 2002 to convert my Access 2000 application to the 2002
format. I then reversed this, and used access 2002 again to convert
the converted database back to 2000 format again. Now I tried using
the resulting database in Access 2000. This way I could check if my
users with Access 2k will be ok.
Well, there were problems with the references and the application does
not work. This means I will not be able to distribute my application
to users with Access 2000, so unfortunately I cannot upgrade.
My application has a reference to Word 9 Object library. It seems that
when converting an application to Access 2002 format, its references
are automatically updated to the Word 10 object library. But when
reversing the process, and converting the application back to the
previous format, these references are not changed again, so they
remain directed to the Word 10 object library. This object library
will not exist on a computer with Office 2000, and do the application
halts.
Can anyone shed some more light on this? Are my only options to not
upgrade or alternatively to use late binding, which will hurt very
much the performance of my application?
Thanks for any input
Gilad