@mr-jones said in Taking suggestions about x86 Access replacement:
Okay, let me preface this with "I'm not a database guy". Moving on.
We have two users who require 32bit Office suite to open a very old Access database. They are the only two in the entire organization who need 32 bit, and it's getting really old having to do everything for the OTHER database that EVERYONE uses (to include them) in both 64 and 32 so they can still use both.
My first and only idea so far is to swap them over to x64 Office suite, and then using VirtualBox or similar, make them a VM with x86 Office suite so they could run the old database.
This isn't a great solution, imo. These folks are not tech savvy and I feel like throwing a VM at them would make their heads explode.
I'm looking at Microsoft Access alternatives, but my priority would be to ensure the the database would function the same, and have the ability to be replicated or be imported from the old one with minimal issues. I don't know a lot about database stuff, and this just doesn't seem like a thing to me, or at least something where the solution would require me to rebuild everything from the ground up to match the old one, which at this point, I'm unable to do in any timely manner, but I'm open to suggestions and actively trying to learn about it.
Convert the access database to SQL and put it on Azure SQL on a tiny instance that's only spun up when uou need it