Home Forums Microsoft Access Microsoft Access Migrated DB to 2016, having ODBC Access problem RE: Migrated DB to 2016, having ODBC Access problem

  • February 13, 2018 at 3:58 pm

    #1979670

    briancampbellmcad - Tuesday, February 13, 2018 3:16 PM

    I'm using or rather allowing Windows Authentication for each user. I'm using Access 2010. I have checked my test user and they have read/write privileges to the database. The user is in the dbo Schema. from SSMS I granted Read, Write, Update, Delete privileges to the user.

    Login mappings won't be in the database itself. Logins are for the server and users are for the database. Login mappings indicate what databases the logins have access to. The login allows the connection to the server and then a login is mapped to a user in whichever databases.
    In SSMS, go to Security -> Logins. All the people who need to have access should have their logins listed there. Right click on a login, select properties. On the left of the login properties page, click on user mappings.

    Sue