Results 1 to 4 of 4
  1. 08-02-2024, 04:17 PM #1
    DesertRat
    DesertRat is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    8

    Record deleted in table

    I have a large database that I deveolped. Someone have deleted the data in a record in one of the main tables, and access will not let me delete the record. Nor will it let me run the queries that are associated with the table.
    Any ideas on how to delete the record?
    Click image for larger version.  Name: DeltedRecord1.JPG  Views: 16  Size: 37.0 KB  ID: 52073Click image for larger version.  Name: DeletedRecord.JPG  Views: 16  Size: 8.1 KB  ID: 52074
    Reply With Quote Reply With Quote
  2. 08-02-2024, 04:30 PM #2
    DesertRat
    DesertRat is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    8
    There was a solution already posted. Solved.
    Thanks
    Reply With Quote Reply With Quote
  3. 08-03-2024, 02:07 AM #3
    Welshgasman
    Welshgasman is online now VIP
    Windows 11 Access 2019
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,569
    Care to share it?
    This site is here to help after all?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
  4. 08-05-2024, 01:05 PM #4
    DesertRat
    DesertRat is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2018
    Posts
    8
    Yes, I ran compact and repair database. That fix the issue.
    Thanks
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Either BOF or EOF is True, or the current record has been deleted _ ERROR while search record from
    By manissinha in forum Access
    Replies: 8
    Last Post: 07-23-2017, 02:04 PM
  2. Record is Deleted
    By Middlemarch in forum Access
    Replies: 3
    Last Post: 07-28-2016, 06:50 AM
  3. Table shows deleted record but it won't delete
    By khughes46 in forum Access
    Replies: 3
    Last Post: 09-19-2014, 09:35 AM
  4. copy deleted record to another table
    By abusaif in forum Access
    Replies: 2
    Last Post: 06-01-2013, 07:04 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums