Forum Discussion

Neuro-VISION's avatar
Neuro-VISION
Copper Contributor
Feb 20, 2022

Will Access 2019 Run an Acess 2000 mdb?

I use Office 2010, which I've had to re-install after a reformat. Unfortunately I guess Microsoft doesn't support Office 2010 anymore, so none of the bugs in my copy have been updated, and therefore ...
access
  • George_Hepworth's avatar
    George_Hepworth
    Feb 21, 2022
    My lack of naivete prevents me from saying flat out "it'll work", but that page is reassuring nonetheless. Having been around long enough, I will believe it completely when you report success.
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Feb 20, 2022

Neuro-VISION 

Somewhat surprisingly, it sounds like it might be possible.

 

That page says, in part,

The .mdb file formats

Before the .accdb file format was introduced in Access 2007, Access file formats used the .mdb file extension. There are multiple different versions of the .mdb file format.

You can still open some .mdb files. If the file is stored in the Access 2002-2003 or Access 2000 file format, you can open it and use it normally. However, you cannot take advantage of features that require the .accdb file format.

Neuro-VISION's avatar
Neuro-VISION
Copper Contributor
Feb 21, 2022
Thank you so much George. I have no need for any advanced features or replication, so running my databases under Office 2019 Pro looks like an easy out of my Office 2010 freezing problems.
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Feb 21, 2022
    My lack of naivete prevents me from saying flat out "it'll work", but that page is reassuring nonetheless. Having been around long enough, I will believe it completely when you report success.
    • isladogs's avatar
      isladogs
      MVP
      Feb 21, 2022

      Neuro-VISION

      It OUGHT to be OK :~>

       

      All versions of Access can still open files created in Access 2000 or later.

      In fact, they can also still save files in Access 2000 or 2002/2203 format.

       

      However, I would still recommend converting your files to ACCDB format as the newer file format is more secure. 

      Access 2019 and 2010 share the same file format so upgrading shouldn't cause any new issues in theory.

      Of course, there are caveats e.g. where features that were in the earlier version have since been deprecated e.g. user level security dropped with ACCDB format, pivot tables deprecated in 2013 etc.

      Also newer versions of Access are less tolerant of 'sloppy' coding. Things that compiled in A2000 may no longer do so in some cases

       

      Good luck

      • Neuro-VISION's avatar
        Neuro-VISION
        Copper Contributor
        Feb 21, 2022
        Thanks for your reply and advice. But as I stated in my original post, I already tried converting to an accdb, and got hundreds of problems in my VBA code. Man others have posted that this is par for the course. I have no intention of spending a couple of hundred hours fixing bugs created by conversion. This is only one of the complex databases that I've developed over the years and still use, and it has many thousands of lines of VBA.

Resources