Upgrading Access 2000 apps to Access 2003
Posted on 2004-11-22
We are upgrading our Office suite to Office 2003 (which includes access 2003). I have written over 60 apps for our company. They are all presently in Access 2000. I tried to stay current as we upgraded our Access versions. I would like to upgrade the Access 2000 apps to Access 2003. Do you have any advice for this undertaking. I've checked the references and here is what I use:
OLE Automation, Microsoft ActiveX Data Objects 2.1 library, Microsoft Office 9.0 Object Library, Microsoft Access 9.0 Object Library, Microsoft Visual Basic for Applications Extensibility 5.3, Microsoft DAO 3.6 Object Library, Microsoft Graph 9.0 Object Library, Utility, Microsoft CDO 1.21 Library
Are all of these supported in Access 2003? Do you think I should update any?
Some of my db's connect to email (they have the ability to create emails though the db), graphs in some reports, some Word merges. I can't think of any other major things they do.
The reason I want to update is because I read about the security things and I know they will "accidentally" try to update the database without really meaning to. So I thought I should do it first. I want to avoid the "pop-up" boxes...
What are the steps I should take in order to updgrade the db's to 2003?
Any advice is greatly appreciated...