I'm new to Docker and exploring options to migrate Access databases from my work's Citrix environment to the cloud. I've read that while you can run Windows in a container, you can't directly containerize Access. I'm considering configuring a Windows container with Office and ODBC connections for this purpose. Has anyone tried this? Any advice or insights would be greatly appreciated!
4 Answers
How do you currently connect to your Access database from different clients? Understanding that setup could help clarify if your approach might work!
Running Windows in a container isn't straightforward. While you might think about using Docker, it's typically better to use dedicated virtualization tools instead. Cloud services usually offer VM services rather than nested virtualization options for containers. It’s often more effective just to run a regular VM for this kind of task.
I think it’s important to ask if you *should* do this rather than if you *can.* It sounds a bit complex and possibly fragile. Have you considered migrating your databases to MS SQL or another more robust solution instead?
I get what you're trying to do, but you'd likely have better results using traditional VM software instead. Using Docker for this purpose might complicate things without significant benefits, especially if performance is a concern. RDP into a standard VM would probably make more sense in this case.
We have an Access front end interfacing with an SQL database that's hosted on a different server.