Results 1 to 3 of 3
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    479

    Table in behaving weirdly

    Something unexpected happened and now when I open my table and try to edit a certain field I'm told



    Your changes cannot be saved because the field 'fName' has been updated by another user.

    There's no other user. I've restarted Access but no change. The field contains "#Deleted" which I did not put there.
    The rest of the record looks ok, and can be edited just this field is having a hissy fit.
    How might I get it to accept new text ?

    If I try to copy the whole table, it won't. Tells Me Record is Deleted. Although the record can be seen.

    Any idea what's going on ?
    Thanks.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,927
    sounds like corruption. Try compact repair and if that fails try creating a new table and import all records except the deleted ones (exclude on the PK)

    INSERT INTO newtable
    SELECT * from oldtable
    WHERE PK not in (3,6,8...)

  3. #3
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    479
    Thanks @CJ_London. All sorted.

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

Similar Threads

  1. rs.NoMatch Not behaving the way it should
    By craig1988 in forum Modules
    Replies: 2
    Last Post: 01-21-2015, 09:50 AM
  2. ADODB Recordset behaving strangely
    By RayMilhon in forum Programming
    Replies: 4
    Last Post: 11-04-2011, 12:21 PM
  3. Recordset not behaving as expected
    By jgelpi16 in forum Programming
    Replies: 4
    Last Post: 02-15-2011, 04:25 PM
  4. intellisense not behaving
    By avianrand in forum Programming
    Replies: 3
    Last Post: 06-18-2010, 04:59 PM
  5. Replies: 0
    Last Post: 10-21-2008, 10:51 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