Here on my Windows 7 64-bit system, I can use ODBC to access any MS SQL Server database on any server I like. Why do you think that doesn't work any more in Windows 10?
And I see no reason at all why 64 bit Office wouldn't work with it, although I only use ODBC in combination with MS Access XP (yes, 2002) and 2003 on this 64-bit Windows 7.
Better ask the experts that wrote your programs what they think about it and what they can do for you.
My knowledge of software is extremely limited. I eventually migrated from a desk top computer to a lap top. The laptop has Windows 10 and Office Professional Plus 2013. The office is the 64 bit version. All was installed by experts and works well. I am a lazy by nature so I try to automate everything. This way no finger trouble or misfiling of documents. The software providers wrote various programmes for me to do this all, and has worked 100% for the last 10 years. They use a Microsoft product called ODBC.
But I have a major and very serious problem. ODBC only works on a 32 bit system not 64 bit. I must uninstall the Office 64 bit and reinstall the Office 32 bit. Also no problem and again I would get experts to do this, as the chances of me screwing it up are extremely likely. I also believe that you can never have enough sex, beer, money or backups, so those gaps are blocked. My problem is, I have been told, is that the emails I have on the Outlook 64 bit version I will not be able to read on the Microsoft Outlook 32 bit version. I don't want to lose any emails, as I do have reason to go back on emails pretty regularly. I try to handle and "sign off" all emails immediately, but often I would at a later date have a query relating to a prior email. If I haven't got the email I am up the creek without a paddle.
Is there anyway I can "convert" my existing 64 bit email file to a 32 bit email file?