Avatar of Larry Biederman
Larry Biederman
Flag for United States of America

asked on 

Access with Sqlserver database with Access front end is on network drive

Hi Experts,
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.

Thanks, Larry
Microsoft AccessMicrosoft SQL Server

Avatar of undefined
Last Comment
Larry Biederman

8/22/2022 - Mon