Here is my setup.
Access 2010, SQL Server 2016 Std Edition
On my server i have Express, Developer and Standard edition installed
Users are connected though ODBC File.DSN (on a shared network drive) using Server = ServerName(IP Address)\InstanceName,PortNumber
I have 50 users connected at any given time with no problems. However i have 2 user who constantly get this error throughout the day. If they restart their computer they can reconnect for about an hour then it happens again. I'm out of ideas at this point.
See attachment for image of error.
Any help is appreciated.
Access 2010, SQL Server 2016 Std Edition
On my server i have Express, Developer and Standard edition installed
Users are connected though ODBC File.DSN (on a shared network drive) using Server = ServerName(IP Address)\InstanceName,PortNumber
I have 50 users connected at any given time with no problems. However i have 2 user who constantly get this error throughout the day. If they restart their computer they can reconnect for about an hour then it happens again. I'm out of ideas at this point.
See attachment for image of error.
Any help is appreciated.