hello mates,
first thread here and i hope i haven't missed something even though i searched through forums .
i'm not expert for access but learning quickly and trying many things.
anyway i'm building access DB with user interface forms for my new work.
so far i'm doing okey trying many things but...
the File will be shared with 104 persons working in my department and i want to fully secure it ! means....
nobody see the VBA codes , nobody can edit designs , nobody can open the tables or queries except those i put on (forms, reports, linked buttons)
some people have basic knowledge of access , so hiding navigation , ribbons etc won't be totally safe
i want make it like an Application only user interface
1- What Steps should i do ? for full security !!!
2- what can i do if i upgrade the DB with more forms and i want to replace the 1 at work without losing any data , just like another version with more options
3- last question i've been trying to make button in a form to select specific record and delete it from DB if it matches the written in TextBox (tried macro and VB) kinda stuck.
eg. texbox = Name , the button search in EmployeeDB for that name and delete the whole record with all its data (i could get it by simple combo box but for user faults i want it written value to prevent mistakes)
first thread here and i hope i haven't missed something even though i searched through forums .
i'm not expert for access but learning quickly and trying many things.
anyway i'm building access DB with user interface forms for my new work.
so far i'm doing okey trying many things but...
the File will be shared with 104 persons working in my department and i want to fully secure it ! means....
nobody see the VBA codes , nobody can edit designs , nobody can open the tables or queries except those i put on (forms, reports, linked buttons)
some people have basic knowledge of access , so hiding navigation , ribbons etc won't be totally safe
i want make it like an Application only user interface
1- What Steps should i do ? for full security !!!
2- what can i do if i upgrade the DB with more forms and i want to replace the 1 at work without losing any data , just like another version with more options
3- last question i've been trying to make button in a form to select specific record and delete it from DB if it matches the written in TextBox (tried macro and VB) kinda stuck.
eg. texbox = Name , the button search in EmployeeDB for that name and delete the whole record with all its data (i could get it by simple combo box but for user faults i want it written value to prevent mistakes)