Upgrading App From Access 2003 to 2010
Posted on 2015-01-11
I am planning to move a client app from Access 2003 to Access 2010. I am aware of some 2003 functionality that has changed/is different/isn't supported in 2010.
The first is the menu system. The application menu's developed in 2003 are for the most part supported in 2010 but no changes can be made to pop-up menu's. For this reason I thinks it would be best to recreate the menu's in 2010. Based on some prior EE advice I have purchased Ribbon Creator IDBE 2010 for that purpose.
The existing app has a shortcut menu available on all reports. One of the options is 'Export..." Once selected it allows the user to choose the type of export (Word, Excel, RTF etc..) they want. However, when the MDB is run under 2010, selecting this option gets an unsupported function message. I understand that in 2010 the exports are more specific and I will need to create a new shortcut menu with 'Export to Word', 'Export to Excel' etc... I have started working on these menus and have some created.
I also learned that these new menu's are not 'resident' in 2010 and have to be loaded at start up to make them available to the user.
I'm asking those of you that have gone thru the 2003 to 2010 process prior to me to identify other functionality or commands that work differently, or not at all in 2010. Perhaps even areas where the answer is 'The 2003 command/function works in 2010 but can be improved using new features of functionality available in 2010.
I realize there is no one correct answer to this post and will will award the point among helpful responses.