In my company we are having an Microsoft Office 2007 installation. With a production Access 2007 database. This database is divided into a backend database with data-tables (linked Access 2007 tables) + a lot of ODBC linked tables to Oracle Tables + Linked Excel Sheets (Excel 2007). And there is an Access 2007 Front-end which is used by fairly thirty users. And in Addition a lot of vba-code offcourse.
Additional we are using a central workgroup information file (mdw).
What is the best practice for an upgrade to access 2013?
Will the front-end database could be upgraded to Access 2013 without upgrading the backend databases at first ?
I guess all users will need to have upgraded their Access to 2013 at the same time before accessing the upgraded frontend ?
What about vba code compability ?
What about the central workgroup information file (mdw). ?