ODBC Call Failed ( SQL Server & MS Access) (1 Viewer)

ahmedjamalaboelez

Registered User.
Local time
Today, 04:14
Joined
Feb 25, 2015
Messages
27
Good day every one,
I have MS Access as front end, and SQL server database as back end installed in windows server remote machine , and connected by VPN IP Hamachi , I have more than 10 Users , some times some work fine and some times get this only error message , even after error message some tables connected some other not , I tried to search internet , but no real solution concern Access And SQL Server !!
Any One Faces This Before ?
Thanks ,

ERR10054.PNG
 

Minty

AWF VIP
Local time
Today, 12:14
Joined
Jul 26, 2013
Messages
9,248
That looks like a network issue rather than an Access issue.
Access over a VPN will be about a reliable as a chocolate teapot I'm afraid unless you have at least a permanent 100Mb connection between the two end-points, and the machines are hard-wired.

If you have to use a VPN, then I would suggest a remote desktop solution, where the RDP sessions are hosted on the same network as the SQL server, speed will be great, and the quality of the connection between your SQL server and the end-users becomes much less critical.
 

Users who are viewing this thread

Top Bottom