Results 1 to 2 of 2
  1. #1
    watzmann is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    5

    Just insert new data

    Hi

    is it possible to let users of my database just insert new data to a table but they cannot update or modify old data?



    I have tried using the permissions but it seem it doesn't work . , sorry i'm a beginner .

    Thank you

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If the DataEntry property of the form (on the data tab) is set to YES, the form *only* displays new records.

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

Similar Threads

  1. Insert only permission?
    By wordracr in forum Security
    Replies: 1
    Last Post: 01-14-2010, 04:48 PM
  2. help with insert
    By jamie in forum Access
    Replies: 1
    Last Post: 11-16-2009, 06:02 AM
  3. automatic row insert
    By Jerry8989 in forum Forms
    Replies: 7
    Last Post: 09-29-2009, 06:50 AM
  4. Attachment data type INSERT INTO not working
    By LouisLouis in forum Programming
    Replies: 0
    Last Post: 09-27-2009, 02:23 PM
  5. Avoid jump to first data after insert new picture
    By gigolomoden in forum Programming
    Replies: 0
    Last Post: 08-04-2008, 10:08 PM

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