Runtime to let an Access 2000 app run in Windows 11

[aterry51]

I have a legacy app written in Access 2000, which is still in continuous use. Around 2021 the .mdb became an .accdb, but I don't remember how. We have been running it for years on a windows 10 machine using the Microsoft Access Runtime 2010. It is a 64 bit machine running 32 bit Office. So now that machine is dying and I am trying to port this to a Windows 11 box.

Can I get here from there?
The 2010 runtime is discontinued, but there is a 2016 runtime.
The new machine is 64 bit and has a 64 bit copy of Office Home 2024 installed. The 64 bit Access 2016 runtime refuses to install because my current Office is Click to Run. The 32-bit version of the runtime refuses to install because my Office is 64 bit.

On the probably mistaken assumption that the Access runtime would be a standalone thing that shouldn't care about the current Office, I managed to find the old (32 bit) MSACCESS.EXE and a manifest that goes with it on the Win10 machine. But I have no idea how to install it.



Can anybody suggest a way forward?
* I recently bought the PC from Dell, and they installed the 64 bit Office. Presumably I can convince them I need a license and/or link to a 32 bit Office I can replace this with. I am wary of uninstalling a full Office, but I don't see a reason why this PC needs a 64 bit version. But is that going to land me in Click-to-Run trouble? I kinda doubt Microsoft offers a MSI for Office 2024
* Any way I can get this to run in a 64 bit runtime? The old app has simple VBA, mostly to run the UI screens. There are no Declare statements or anything "advanced" If there is a 64 bit, CtR runtime, the app has a fighting chance of working.

thanks, Allan

------
"He had the look of one who had drunk the cup of life and found a dead beetle at the bottom."
--― P.G. Wodehouse

[aterry51]

I think I give up on this. The standalone version of Access 2024 is recently out. I assume that can read .accdb files from previous versions, including 32 bit versions. I'll buy that. I do wish the Microsoft page where they sell the standalone version would bother to say if it is 2021 or 2024.
Allan

[Welshgasman]

If there are no Declares in your DB, than I would expect it should run once compiled in 64bit.
I bought 2019 Lifetime for around £20 purely as my 2007 would not open later dbs.

Groupon are contantly offering 2019 for around the same price if not less.

To convert from mdb to accdb, you must have had a later version somewhere. I can do that with 2007. It appears I can also do that with 2019.

[alansidman]

See if your employer subscribes to the Home User Program and save lots.

https://www.microsoft.com/en-us/work...scount-program

I pay $50 per year for O365 and get the whole suite.