January 22, 2004 at 8:59 am
What is the best strategy to handle forms which can be accessed by users with and without permissions to the data . This is the first time that I have had to deal with multiple permissions and the users without permissions get error messages when opening a form(that they don't have permissions to). I would like to trap itheir permissions then act accordingly, but I am not sure where to start or look.
Thanks in advance.
fryere
fryere
January 26, 2004 at 7:16 am
what is your FrontEnd application Tool (is it .net .. or Access or what ??
Alamir Mohamed
Alamir_mohamed@yahoo.com
January 28, 2004 at 12:18 pm
Right Now I am Using Access 2000, however I may migrate over to VB.Net later on.
fryere
February 15, 2004 at 2:31 am
if you are using Access .. then use Access Security (Workgroup Admin) to make a file (filename.mdw) and adjust all users WorkGroup Admin to connect to this file ... another solution if you use .net is to Make a tables Users, Objects and permissions .. and make a select statement on these tables when anyone open a form to know if he has permisssion or not to open it (also you can make table Groups ,, and out permissin to groups)...
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply