Hello,
I have read in multiple locations that Access 2007 does not support user security levels, and I have tried the RunCommand WorkgroupAdministrator Macro MS suggested. I really do not know what that Macro does, or how to use it. Anyway, I was wondering if what I have done is sufficient for regular user levels and Admin users. I created a log in form that links to an Employee table with name and password, the log in button is coded using VBA that basically grants or denies access. If the username and password match what is in the table, they are taken to the main switchboard where everything is read only except adding a record using the add record form. Now, I also created an Admin table and added an Admin log in button to the log in form. The button is coded to grant access to the users in the Admin table. If the username and password matches the Admin table, the user is taken to an Admin form where everything is read and write, and has extra options. Where I run into a problem is being unable to right click and go to design view since I have disabled that under Access options. Is there anything I can do to allow design access to certain users, and is what I have done ok?
Thank you
I have read in multiple locations that Access 2007 does not support user security levels, and I have tried the RunCommand WorkgroupAdministrator Macro MS suggested. I really do not know what that Macro does, or how to use it. Anyway, I was wondering if what I have done is sufficient for regular user levels and Admin users. I created a log in form that links to an Employee table with name and password, the log in button is coded using VBA that basically grants or denies access. If the username and password match what is in the table, they are taken to the main switchboard where everything is read only except adding a record using the add record form. Now, I also created an Admin table and added an Admin log in button to the log in form. The button is coded to grant access to the users in the Admin table. If the username and password matches the Admin table, the user is taken to an Admin form where everything is read and write, and has extra options. Where I run into a problem is being unable to right click and go to design view since I have disabled that under Access options. Is there anything I can do to allow design access to certain users, and is what I have done ok?
Thank you
