Results 1 to 3 of 3
  1. #1
    bauer1544 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    8

    Allow edits set to no but i can still edit data


    I wont even begin to get into the multitude of problems that just occurred out of nowhere. But simply put AllowEdits is set to NO and i can still edit the record. I am quite literally dumbfounded i cant find anything else on the internet about this or with this happening and its happening all over my database out of nowhere. Ive tried setting it to no in the properties as the default and getting rid of my VBA command to set it to NO ive tried setting it to yes and setting me vba command to false and every other which way it just refuses to work for me.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    I wont even begin to get into the multitude of problems that just occurred out of nowhere.
    Strange behaviour can be caused by corruption.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Are you modifying the record in code? That over-rides the Allow Edits restriction until the record is saved, then the property will be reset. However, I don't know if that applies only where you have set the property in design, or if it also applies to when you set it in code. If you don't need a form recordset to be editable at all, it's easier to just open it with a snapshot type recordset.

    If it happens throughout the db and it's a new behaviour, then maybe it is corruption as suggested.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Only can edit one row of data
    By Syla in forum SQL Server
    Replies: 7
    Last Post: 05-05-2020, 01:15 PM
  2. Cant edit data
    By Syla in forum SQL Server
    Replies: 3
    Last Post: 03-15-2020, 11:43 PM
  3. Replies: 14
    Last Post: 02-24-2017, 12:59 AM
  4. Edit Data in Recordset
    By Bwilliamson in forum Programming
    Replies: 3
    Last Post: 05-12-2011, 08:29 AM
  5. UnMatched Data Query (Edit Data)
    By pedraza4 in forum Queries
    Replies: 3
    Last Post: 06-16-2010, 07:29 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