Access 2003, MS SQL & access control

L

Leif S

Hi anybody,

I try to implement access control on my Access 2003 application running with
the MS SQL as the database engine. I want to make sure that the user's access
to the application is according to their specified roles . Have stepped
through the security features in Access. (User & Group Accounts etc.). Have
also implemented a role (Standard Role) and linked users against this role on
the SQL Server. In the Data Link Properties, I have specified Windows NT
Integrated Security.

When I start the application and log in as a user with limited access, no
login screen appears and no limitations are applied to the data retrieval and
handling.

Any idea what I should do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Using Application Roles with Access MDB's 0
Access 2007 Application for Reports Only – SQL Server Security 3
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Role-based Security 0
Application connects to Oracle database 0
Keeping Access Running Between SQL Server Reboots 3

Top