Migrate Access to SQL Server

[myukas]

We converted an Access 2016 database to SQL Server using the migration tool. We have also linked the existing Access form to the SQL Server database. We some users are using the form it works perfect. Other users are getting all kinds of connection errors and we can not figure out why

[ranman256]

check their ODBC connection. Or even remove it and add it again.
make sure you use the most recent ODBC driver for your flavor of SQL.

[myukas]

So we should check on each user PC

[Gicu]

Each user must have on their machine the same driver used to link the SQL tables. So if you linked the tables on a machine using SQL Server Native Client 11 then all users must have that driver installed. And I assume that they share a SQL login (user/password). Otherwise (if you are using Windows authentication) you have to check their permissions

Cheers,
Vlad

[myukas]

that makes perfect sense thank you

[ssanfu]

Also,
Each user has their own COPY of the FE on their computer?
No one is connected over a WAN?
No one is connected wirelessly?