Results 1 to 4 of 4
  1. #1
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340

    Record is Deleted

    Access brought up a message while editing a field. I can't quite remember details but offered 3 options, none of which I wanted.

    Now that field shows '#Deleted' and when I try to remove it a msgbox says "Record is Deleted"

    Well, it is NOT deleted, not do I want it to be. I've closed and reopened Access but the problem remains.


    How can I 'undelete' it or otherwise have is behaving normally?

    Thanks.
    PS If anyone can identify that message, which of the 3 options means do nothing, just go away. It was something to do with another user
    but there's only me !

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    No, once the record is deleted, it's gone.
    if you see the message ,you must refresh the query/table to remove the messages.
    no undelete.
    there may be a hack to un delete.

  3. #3
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340
    Thanks for reply... it was really weird... only one field had "#Deleted" showing, and the record was not gone.
    After a C&R it all came right. How do you refresh a table ?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    F5, or close and reopen the table.
    If a linked table, refresh the link in link tabl manager.

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

Similar Threads

  1. Record deleted!!
    By sunnyday in forum Queries
    Replies: 4
    Last Post: 07-08-2015, 07:28 PM
  2. deleting record leave at #Deleted
    By markjkubicki in forum Programming
    Replies: 5
    Last Post: 06-02-2015, 07:33 AM
  3. copy deleted record to another table
    By abusaif in forum Access
    Replies: 2
    Last Post: 06-01-2013, 07:04 AM
  4. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM
  5. record deleted
    By akram in forum Access
    Replies: 12
    Last Post: 03-11-2011, 09:23 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