We help IT Professionals succeed at work.

Access 2010 to Access 2019 Compatibility

Hi,

I have an access application coded in MS Access 2010 and I wanted to know if there is an upward compatibility with MS Access 2019.

Also,

Is MS Access can be used as a stand alone application on a PC vs. a subscription License based application ONLY in that case I have to deal with unintended consequences due to updates pushed by Microsoft.

Guidance will be appreciated.
Comment
Watch Question

Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
In a general sense, Access 2010 databases should run fine on Access 2019.  That said, certain features have been deprecated, so you need to ensure none of those are used.  The only way to know for sure is to test.

The real consideration with Office 2019 is that it is only compatible with Windows 10!  It won't run on Win 8, 7, Vista, ...  You can install stand alone version of Access if you have the license.  You can also install the Office365 runtime,

Author

Commented:
Thanks Daniel,

Yes, I know testing on the new version will be the ONLY way to know about ANY Compatibility issues. I have read some info inline regarding MS Access 2019 and cam to know that you can install it on standalone PC since MS Access 2019 can be bought with a one time "perpetual license" correct? and so I should not be worried about any updates from MS which might (or might not) create issues in the future.

Also when I say standalone PC it means that it is outside the regular IT backup and maintenance scope etc
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
The Perpetual licensed version Office/Access 2019 will not receive any updates (outside of security/bug, but no new features).  So it will be a static version basically.

Only the Office 365 will get new updates and enhancements.  It is Office 365 that is/will remain the volatile version!!!!

Author

Commented:
So you are saying that the updates for security/bug fixes will be essentially harmless? Correct.

And it will not impact the functionality of the MS Access upgraded application.
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
security/bug fixes will be essentially harmless
Historically, I'd say yes, but since Office365 surfaced I'd be more inclined to say no.  MS has a very bad track record for updates in the past 2-3years on all fronts (OS and Office).  Not sure what Office 2019 holds for us.  Your guess is as good as mine.