ODBC connection fail in remote computer

[uoghk]

I use Link Manager to connect SQL Server in my local computer.
My Access program works fine to retrieve/update the SQL database.
On another computer, I map the folder of my Access program as a network drive Z:.
I want the user open Z: drive, then double click my Access program to run it.
But I get error : 3151 ODBC connection to ODBC Driver 17 for SQL Server mysql2019server failed.
mysql2019server is my local computer name.


I create ODBC Data Source in Control Panel and I success to connect to mysql2019server.

[ranman256]

Do NOT map linked files with drive letters.
always use full UNC paths: \\server\folder\file.accdb

[uoghk]

don't understand using full UNC path.
In File Explorer, i type the full UNC path to open the Access program.
It gets the same error.

[Minty]

The Access program should be a front end on the the local computer, not on a network drive.

Then use a UNC path to link to the back end data.