Recent content by jayhamz

I keep getting access denied even though i want to deny just 2 and 3 please help table (Accesslevel) 1 Manager 2 .......... 3 ......... Private Sub Form_Open(Cancel As Integer) If DLookup("AccID", "tblSecurity", "[SecID]=" & Forms!frmLogin!CoUserName) >= 1 Then MsgBox "ACCESS...

I'm trying to restrict users by defining their access level so 1 Developer (can access all tables,queries,forms and edit) 2 Administrator (can read,edit forms,queries) 3 Editor 4 Reader (can only read) Heres my code, don't know how to go about it pls help Option Compare Database...