Role

Mar 20, 2007

Hi,

I created the table1 and one application role (read/update permission) in SQL Server, and then link the table1 to the MS Access.
I created the form1 in MS Access, and attach the recordsource = table1, and I write the codes which execute the application role (make it active) in order to access the table on that form. I put the code on Open, Activate, and Load events action.
However, the program does not allow us to do that.

How can I do for this?

I do not want to create the standard role, and assign user to the group, because the user may import the data from SQL Server directly if the user create their own file, since the group will give read permission. I want to limit the user to access the table only in the file I created.

View Replies

General :: Redirect Role To Specific Form?

Nov 26, 2012

I've created a log in system with a tutorial I've found on YouTube. It simply redirects users to a specific form after a successful log in. Here is the code:

Code:
Public Sub Login()
On Error GoTo ErrorHandler:
If IsNull([cboUser]) = True Then 'Hier wordt gechecked voor de UserName

[Code].....

The users are defined in tabel "tblUsers". All users are now redirected to the form "frmMenu" which is good.

However, I would like to know how to add an exception. For example

1) All users should be redirected to frmMenu after a successful log in. (Check)
2) The user called "Management" should be redirected to an other form "frmMgm"

I've searched on the internet on how to do this but without luck. (forums.asp.net/t/1775325.aspx/1)

So in short:

IF user "Management" logs in THEN redirect to frmMgm (or whatever form)

View 6 Replies

View Related