Home Forums SQL Server 2016 SQL Server 2016 - Administration Access users can't use SQL 2016 (?) RE: Access users can't use SQL 2016 (?)

  • February 6, 2018 at 1:53 pm

    #1978786

    Evgeny Garaev - Tuesday, February 6, 2018 1:34 PM

    Check that you can connect from the user/application pc using an odbc connection. If that is possible trace the SQL Server instance and make sure that Access is actually trying to connect to the server.

    The user can read any table of the DB through SSMS, but cannot through Access even though the ODBC linked tables are accessible to me through the Access database. From the user's machine in SSMS I can access anything with their loin, but I can't do anything through Access with her machine, even directly opening the tables or using the linked table manager.