Folk, I need your help to set the roles in my database. Attached an access database linked to a SQL server with an example of what I mean. To avoid the incompatibility of logical fields (i.e. yes no fields) with SQL I replaced them with short texts (i.e. value list = row source time and under the latter I set the options I need (i.e. yes/no) please see TBLPrivilege attachment. Then I adjusted module 2 and replaced 'false' with the option I set for the users, who do not have a specific authority or role. Still, going through all that did not get me the result I want.
Here the expansions of the acronyms and abbreviations you may come across while skimming through TblPrivilege:
COpen = the user can open form
Cadd = the user can add form
Cedit = the user can edit form
User Name: Hiba
Password: 54321
Regards,
Here the expansions of the acronyms and abbreviations you may come across while skimming through TblPrivilege:
COpen = the user can open form
Cadd = the user can add form
Cedit = the user can edit form
User Name: Hiba
Password: 54321
Regards,