I have successfully moved Access back-end tables to SQL server 2012, using SSMA for Access.
I can place the front-end (with all the links to SQL) on either my C:\ drive or on the server and it work.
But no other computer on same LAN can attach. They get an ODBC connection error.
I've tried having SSMA create links, and have manually created machine and file ODBC links.
Any ideas appreciated.