Problem workbook with automatic links from a SQL database via ODBC.

Marcel Van Mensel 1 Reputation point

I created a workbook with automatic links from a SQL database via ODBC.
This workbook must be used by 5 people individually on their own computer.
I can update the link on my computer without any problems,
but when i want to update workbook on another computer he gives an error message that he can't find the database
Although all the settings that need to be set (ODBC, SQL etc.) are set on all computers as on my computer, he continues to give this error message.
I can access and view the database on each computer individually, but the links don't work.
Does a setting still have to be set somewhere or do I have to call up the workbook links on each computer separately?
Is the intention, if something is adjusted to the workbook, a copy is simply sent to these five other users and that they can automatically perform the possible update of data from the database themselves.
Gladly answer El Marcel

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,641 questions
0 comments No comments
{count} votes