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.
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
- 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.
It is true that later versions of Access are far less tolerant of ambiguities in code, and that, moreover, there are often improved ways to accomplish things.
For example, at one time a statement like this was quite acceptable in Access VBA.
Public Function DoThis()
Dim db as Database
---do something with db
End Function
In more recent versions, one would probably need to qualify that more carefully and explicitly.
Public Function DoThis()
Dim db as DAO.Database
---do something with db
End Function
The same is true of a number of other coding practices. Greater explicitness is more likely to compile and run cleanly.
In the end, though, as long as the existing solution meets your needs, that's what matters.
