none
How long the access database having extensions .mdb are supported?As now all the office versions after 2003 have an extension of .accdb RRS feed

  • Question

  • Hi All,

    Can you please let me know, how long microsoft is supported the backward compatibility?

    Currently we are using access database having an extension of .mdb so just wan to know is there any plan to discontinue its support?

    Thanks

    Thursday, September 7, 2017 7:05 AM

All replies

  • Hi. I think the last version of Access that can open a .mdb file was Access 2010, which life cycle support has already expired. So, when you can no longer run Access 2010, you won't be able to use your .mdb files anymore. Hope it helps...
    Thursday, September 7, 2017 12:30 PM
  • That's not correct. A2016 can open them too.

    Yet the OP would be smart to see the writing on the wall, and gradually convert to the new format.


    -Tom. Microsoft Access MVP

    Thursday, September 7, 2017 1:55 PM
  • Well, it can open the latest flavor, but not  the older one (2.0, '97).

    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, September 7, 2017 2:45 PM
  • No one can truly answer that question except for Microsoft and they won't come here and share their plans.

    Over the years, we've seen support slowly fade away.  Office 2016 still support mdb files, but only the latest flavor of them.  So older '97 mdbs can't be opened.  Considering this and the fact that accdbs have been out for 11 years now, I think it would be a wise move to consider upgrading the file format to avoid any ugly surprises that the future may hold. 

    All that said, who knows, perhaps the mdb format will continue to be supported for another decade?!?  Your guess is as good as mine.


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, September 7, 2017 2:48 PM
  • I would have to agree with Daniel, nobody but Microsoft really knows. But if I would have to speculate I would say that when Microsoft removes the Jet Database Engine (which has been deprecated) from the OS that will be the end of the .mdb. In other words, probably when the 32-bit world ends, which may be a very long time from now.

    In the meantime, why not upgrade?


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, September 7, 2017 4:36 PM
  • Hi Nitika_V,

    Has your issue been resolved? If it has, I would suggest you mark the helpful reply as answer which is the way to close a thread here.

    >> Currently we are using access database having an extension of .mdb so just want to know is there any plan to discontinue its support?

    As far as I know, there is no such plan which will discontinue its support. Kindly to keep go with your project. And there is no need to wrong about discontinuing mdb, we could convert .mdb to .accdb file format easily.

    # Convert a database to the .accdb file format

    https://support.office.com/en-us/article/Convert-a-database-to-the-accdb-file-format-098DDD31-5F84-4E89-8F44-DB0CF7C11ACD

    Best Regards,

    Edward


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, September 12, 2017 2:19 AM