Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2015
    Posts
    1

    Unanswered: How to remove #deleted record in Access table

    I am not a programmer. I have read the threads already on this topic.I have created an access database that tracks a small group of patients for a pilot program. I have split it into front end and back end and several users have a local copy of the front end from which to enter data. The backend is stored on a remote server. I was suddenly unable to run a query off a table and found that one of the records showed #deleted. I attempted to delete it from the table by manually deleting the record, compacting and restarting the db and nothing is enabling the removal of the offending record. I am unable to run any queries since this record prevents the process. Please, in simple terms, can you tell me how I can restore this one table so that I am able to query data from it. Thank you so much.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    It is already deleted...the table just happened to be on the record when it vanished.
    Refresh the screen and the #deleted will vanish.

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Use a VBA Sub or Function in the module of the form displaying #Deleted:
    Code:
    Private Sub RefreshData()
        Me.Requery
    End Sub
    It cal be called from a command button or, if it's really needed, from a Timer Event.
    Have a nice day!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...but why would that #' I am unable to run any queries since this record prevents the process.'.....
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •