Hi,
I have a question regarding security. I don't want the users with a given password to be able to type values directly to the tables. My program works as follows:
I have a *.mdb file with tables only (back-end). I access the data using an interface (front-end) in MSAccess 2000 and link the tables. My problem is that users can type values directly to the tables (modify data) instead of using the forms. How can I hide tables/queries or prevent the user from updating the values directly? I was able to hide modules, reports, forms and macros by assigning passwords using workgroup level security. I also use an MDE file to prevent the user from modifying the code in VB. However, my only problem now is how to prevent the user from updating values directly into the tables/queries.
Thanks!
Luis.
I have a question regarding security. I don't want the users with a given password to be able to type values directly to the tables. My program works as follows:
I have a *.mdb file with tables only (back-end). I access the data using an interface (front-end) in MSAccess 2000 and link the tables. My problem is that users can type values directly to the tables (modify data) instead of using the forms. How can I hide tables/queries or prevent the user from updating the values directly? I was able to hide modules, reports, forms and macros by assigning passwords using workgroup level security. I also use an MDE file to prevent the user from modifying the code in VB. However, my only problem now is how to prevent the user from updating values directly into the tables/queries.
Thanks!
Luis.