I have Access as FE, and SQL server as BE via ODBC. The tables are all linked. The server is using SQL server Authentications. In my Access form load event, I will check each user’s NT id to make sure if it’s matching the id of Usertable at BE, if not, a msgbox will say sth llike“You’re not authorized”. So literally users have no login form. But now we need to give some users read-only permissions(some can insert or update), How can I limit them??
p.s. I read from book, it says: If you are using SQL Server Authentication, create a login for the application role to use(assuming I already created an application role in SQL server)
Thanks for your time(especially this time of the week)
Have a great weekend!
p.s. I read from book, it says: If you are using SQL Server Authentication, create a login for the application role to use(assuming I already created an application role in SQL server)
Thanks for your time(especially this time of the week)
Have a great weekend!
