Results 1 to 3 of 3
  1. #1
    sp_1717 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Posts
    2

    Insert/Update Table from form but restrict direct access to Table

    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

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Look up the split database utility. It creates a backend and a front end. All tables are stored on the backend but forms and queries are on the front end. Give each user their own front end with a disabled navigation pane on the front end. It's been discussed here serveral times. Search the forum or hit up google. There's plenty of information about this.

  3. #3
    sp_1717 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Posts
    2

    Thanks

    Thanks Shabz will give that a try

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-20-2010, 03:54 PM
  2. Insert query into table FROM two table sources
    By svcghost in forum Queries
    Replies: 2
    Last Post: 11-05-2010, 09:10 AM
  3. Restrict Table values
    By Suzied in forum Access
    Replies: 1
    Last Post: 03-27-2010, 11:14 AM
  4. Replies: 0
    Last Post: 02-24-2010, 12:56 AM
  5. Replies: 6
    Last Post: 08-17-2009, 01:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums