I am a newcomer to this forum.
Over time I have created a number of complex applications, in commercial use, using Access 2003 and with some exception have managed to control the functionality almost exclusively via macros.  I know, but I am 70 years of age but with a programming background.  I am now faced with bringing at least one system up to Access 2010 level but of course Macro functionality is not a clever as in 2003. I am not adverse to VBA but haven't used it extensively.  How 'safe' is it for me convert all macros in 2003 to VBA functions before migrating wholesale into Access 2010?

---

Reply from Richard Rost:

I've had pretty good success with converting 2003 macros to VBA. There's an automated tool for that. The best advice I can give you is (1) back up your database, and (2) give it a shot. Test it thoroughly in 2003 first, and if everything seems to work, upgrade it to 2010. I would say that 99.9% of all the VBA code that I've ported over from 2003 to 2010 works just fine.