Results 1 to 3 of 3
  1. #1
    Hunt2871 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    2

    protecting records from unwanted edits

    I have a simple database where my co-workers and I enter counts of our daily activites and I need to do something to keep us from editing a record once it is entered. I would like to be able to delete records but this is not critical necessarily. Is this possible or advisable?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    there are properties for this. ALLOW EDITS/DELETIONS/ADDITIONS/etc..

  3. #3
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    Forms!MyFormName.AllowEdits = false

    Place this in your code where appropriate.

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

Similar Threads

  1. Replies: 9
    Last Post: 04-01-2010, 07:23 PM
  2. Unwanted Dialog Box
    By ntallman in forum Programming
    Replies: 3
    Last Post: 03-26-2010, 11:11 AM
  3. How protecting a mdb database ?
    By PaulL in forum Security
    Replies: 1
    Last Post: 01-14-2010, 04:43 PM
  4. Password protecting db
    By lmp101010 in forum Access
    Replies: 1
    Last Post: 12-20-2009, 03:25 AM
  5. Subform creating new unwanted entries
    By Rpatrick in forum Access
    Replies: 1
    Last Post: 08-14-2009, 03: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