$10.00 says AC support will say they didn't cause it. This should have been fixed over the weekend. Not sure what it will do to MedFx, but that is a billing company.
From what you said, it sounds like AC support just guessed it was due to 32-bit SQL. That makes little sense to me. There was no other attempt to look at the network first? Like is there a 10 or 100 Mb/s switch? Why was SQL looked at as the culprit. We have more users than you, and we were still using 32-bit 2005 Express, and it flies. I can't imagine SQL causing performance issues in too many offices.
Here is the deal. I am not sure what the semantics are, but you cannot upgrade from 32-bit SQL to 64-bit SQL. You simply can't. The 64-bit drivers just won't be there. Your fist move would be to try to find 64-bit drivers for the two processes. The only way to do this properly is to uninstall the 32-bit SQL and install the 64-bit SQL. Is this what AC did?
AC makes a product which will run on Windows Server 2012 Standard R2. That doesn't mean they know that OS. They make a product which uses SQL Server for its database. They know what tables houses certain data. But, they don't do support for SQL Server.
A task like that should have been done by someone who knows SQL Server. Someone who can tell you if you will get a performance boost in the first place. I suspect you will continue to have error messages without the proper support fix.
See PM for further detail.
