Results 1 to 5 of 5
  1. #1
    winsonlee is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    4

    Preventing user from accessing the Table


    I have created a few forms in Access. How can I prevent user from opening the table, view and edit the table ?

    I am using access 2007.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  3. #3
    winsonlee is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    4
    Thanks for the link.

    Other then hiding, is there any other way to password protect the table ?

    If the person who uses the form knows their way around, he can still view and change the data in the table ?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You are correct. The only *real* solution that would work is to use a different BackEnd like SQL Server.

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    The short answer is, if anyone knows their way around access there's no way to prevent them from using the back end tables unless you only give them the run time components to run the database. If your users have full versions of access installed there's no clean way to prevent them from touching your tables directly.

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

Similar Threads

  1. Preventing other values in combo box
    By cheese9799 in forum Forms
    Replies: 3
    Last Post: 02-14-2011, 03:31 PM
  2. Replies: 2
    Last Post: 07-01-2010, 07:09 PM
  3. Replies: 1
    Last Post: 02-03-2010, 08:27 AM
  4. Preventing multiple checkboxes
    By emerywang in forum Forms
    Replies: 2
    Last Post: 01-26-2010, 01:43 PM
  5. Accessing Table via asp Errors
    By KLynch0803 in forum Programming
    Replies: 1
    Last Post: 01-17-2010, 09:59 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