accessman2
Registered User.
- Local time
- Yesterday, 20:14
- Joined
- Sep 15, 2005
- Messages
- 335
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.
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.
