Forum Discussion
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 Outlook and the other apps keep freezing with no readily apparent way to resolve this issue.
I'm considering upgrading to Office 2019 Pro, but . . .
I've written a number of VERY COMPLEX Access 2000 split databases over the years. When I say complex, I mean mega thousands of lines of Access VBA code. When I tried to convert one of my databases to accdb format, it left me with hundreds of errors in my code. Therefore, converting my databases is not something that I can consider.
Now for the $64 question: Will Access 2019 reliably run an Access 2000 mdb? I've searched the web and can't seem to find a decisive answer to this question. If it will run an old mdb, Is there anything else I should know before spending the money to buy Office 2019?
- 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.
