VBA changes from Access 2003 to 2010 ?
Posted on 2010-11-26
The (big) bank I'm currently contracting for is planning a huge leap (of faith) from Windows XP and Office 2003 to Windows 7 and Office 2010. I have developed for them a whole suite of MS Access (2003) apps which are all front-end to a MS SQLServer DB, i.e. all front-end apps have virtually only VBA code and more or less GUI in them, and a whole lot of linked tables, but practically no local tables.
What kind of problems could I get on the new platform, apart from things like security / trusted locations, DB format (ACCDB) and such ? Has there been any significant deprecation of / changes to / enhancements of VBA objects/methods/properties between 2003 and 2010 ?
Also, one important Access app is driwing MS Word to open template documents with MERGEFIELD placeholders and IF's, and replaces these with data from the DB. Are there any known changes in that area which could be in the way of that kind of processing ?
Thanks for passing your knowledge in these areas. Any hint welcome !