Forum Discussion
Will Access 2019 Run an Acess 2000 mdb?
- 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.
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.
- 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.
- 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.
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
