Conversion from File format Access 2002-2003 .mdb to Access 2007 .accdb

Question

I have an application which consists of a FrontEnd database and many hundreds of BackEnd databases.  I programmatically CONNECT to one BackEnd database based on user selection.  Presently, the FrontEnd database is compiled and distributed to many sites as a .mde database and all the BackEnd databases (which are site specific and not distributed) are .mdb files.  All the databases at all the sites are in Access 2002-2003 format and I am using Access 2013 to maintain the FrontEnd database where all the VBA modules, forms, reports, small static tables reside and the VBA modules maintain the data contained in the BackEnd tables.  Now for my question ... I recently converted from Access 2003 to Access 2013 to maintain and distribute the FrontEnd .mde file but I obviously did not convert the file format to .accde.  Should I be planning on an additional upgrade to the .accde for the FrontEnd database and .accdb file format, which I can do programmatically, to all the BackEnd databases, or am I safe relying on Microsoft to continue to support Access file format 2002-2003?  Thanks for your time and patience reading this question.

MikeBromley

Answer 1

I believe MSFT will continue to support the 2002-2003 MDB format for a few more years. But eventually, I believe they will stop supporting it.

Answer 2

Thank you, Scott.