Hello
Don't have that much expereince with Access but have a small access db (Access 2003) for a contact/mailing list. I'd like to give a handful of users the ability to read/insert/update/delete contact information (eg. Name, Tel. No. email etc...) through a form but restrict the same users from having direct access to the tables.
Trying to use the user-level security but that's where im hung up, if i remove the users insert/update/delete access to the table, the user can no longer insert/update/delete through the form. If I give them those permissions, they then of course have direct access to the tables.
I could hide the tables but that seems not the proper way to do this. Is this even possible?
Thanks