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.
Blue FinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel PineaultPresident / Owner CARDA Consultants Inc.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,
Blue FinAuthor 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.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!!!!
Blue FinAuthor 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.
Daniel PineaultPresident / Owner CARDA Consultants Inc.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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.