Microsoft Access – Upgrading to 2003

The Office Update page of the Microsoft Web site offers a useful toolkit for analyzing databases prior to converting them to Access 2003 format. It is called the Access 2003 Conversion Toolkit, listed under the Add-ins link under the Access 2003 heading on the page.

Donn Edwards offers a utility called AccessOpener, which avoids those annoying messages when opening a database that is in a different Access format than the version of Access you are running. The utility works with Access 97, 2000 and XP/2002, and it can be downloaded from here.

Web Services, SOAP, MSXML and Microsoft Access

Thinking about integrating Web Services? The PerfectXML website has some great articles about SOAP and MSXML and other technologies that will allow you to do this. I’m fairly new to the world of web services and not yet a proficient .net programmer (VB migration on the way…), but seems to me that Web Services are the thing of the near future.

This article from PerfectXML is a good allrounder that includes stuff on standard asp programming – easy to follow and very logical. I’m particulary interested in simple bits of code and interfaces (perhaps Google or eBay) that I can test using Access 2000 and VBA. I understand that it’s possible without over complicating everything. The recent Access user group meeting (May 2005, UK) was very interesting. Peter Vogel (editor of Smart Access, Pinnacle publication) gave a brilliant presentation of Microsoft Access using SOAP, etc. to access Web Services; so it must be possible. Continue reading