Upgrading from Office 2010 to 365

[Peter Kinross]

For security reasons I am forced to upgrade from Off 2010 to 365. However that leaves me without a database. I restricted myself to 2010 because after that MS, in their wisdom, changed Access so that quite a bit of my years of coding would not work. (I can't even remember what those changes were.) As my entire business runs on it, I will have to still use Access 2010 and, in so far as it is possible, put passwords on the code and macros, with the aim of moving to something compatible with 365. I shudder at that prospect.
Now my question: what is there that has the functionality of Access that is compatible?
Does anyone know of the least expensive way to get 365. I am guessing that there is no such thing and that everyone pays the same.

[HansV]

I'm afraid that there is no database development environment that is compatible with Access.
Keep an eye out for offers of Microsoft 365 subscription at e reduced rate, but be wary of ridiculously cheap offers - those are usually too good to be true...

[Peter Kinross]

Thanks Hans. So what do people do for a Db that is compatible with 365?

[HansV]

Use Access in Microsoft 365...

[Peter Kinross]

But there is no Access in 365.

[HansV]

There is, Microsoft just doesn't advertise it prominently.

[Peter Kinross]

That seems strange.
Is it possible to run Access 2010 and Access 365 on the one computer?

[HansV]

Yes that should be possible. Microsoft 365 uses a different type of installation (click-to-run), so they won't bite each other.

[Peter Kinross]

Well what do you know. I can clearly recall MS saying that DAO won't run after Office 2010. As a result, I have remained with Office 2010 since then. I couldn't change as my entire business is run on Access. for security reasons I have just installed Off 365, but left Access 2010 still installed, figuring that over the next year or so, I will rewrite the code to work with 365. No need - it runs perfectly (so far).
Not very happy with MS, I could have been running the more secure updates the entire time. Grrrrrrrrrr!
But thanks guys for the advice above.

[SpeakEasy]

>I can clearly recall MS saying that DAO won't run after Office 2010

Oh dear. An unfortunate misunderstanding. What they did was retire the DAO 3.6 object library - but they replaced it with the Access Database Engine object (which includes all the DAO stuff)

[HansV]

And what's more, the Access Database Engine is still referred to as DAO:

Dim rst As DAO.Recordset

Etc. etc.

[SpeakEasy]

There is, Microsoft just doesn't advertise it prominently.

Yep, and that's so weird. It's pretty much included in all versions, but clearly listed in very few of them unless you go to the comprehensive "includes" pages, and even then it is sometimes in small print.

[Peter Kinross]

Ah well, all's well that ends well. But it would have ended better if I wasn't saddled with those 12 years of inferior Office.
Thanks again guys, your knowledge is quite remarkable.

[Gasman]

When you start experiencing the bugs that are coming out in Access 365, you might wish you were still using the 'inferior Office' ?

I am still using 2007, but do not use it for anything work related anymore, just personal, and it is fine for me.

[Peter Kinross]

The group I work through is mandating 365 for security and CoPilot