Solved

Access 2010 Query is Returning "Record is Deleted"

Posted on 2016-09-23
5
21 Views
Last Modified: 2016-10-12
I have tried to compact the DB, create a new DB and important all the tables into the new DB, but still getting this error


Any thoughts?
0
Comment
Question by:seamus9909
  • 3
5 Comments
 
LVL 19

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 125 total points (awarded by participants)
ID: 41812845
if the database is on a network drive, move it to a local drive to compact/repair
0
 

Accepted Solution

by:
seamus9909 earned 250 total points (awarded by participants)
ID: 41812913
So copy it from the Network drive to a standalone, Compact and repair, and copy it back to the network drive?
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 125 total points (awarded by participants)
ID: 41812949
At what point during the create and import do you get the error message?  Can you identify the table with the problem?

Create a new database WITHOUT the table in question.  Export the old table to a csv file and then import from the csv file.  

If nothing else works, restore your last backup.
0
 
LVL 19
ID: 41812950
yes -- and I would suggest doing it 3 times. Be sure to back it up before C/R.
0
 
LVL 19
ID: 41839773
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed.  A correct answer was given.

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access Report that will show table changes 7 45
SQL profiler equivalent in MS-Access 3 43
Need more help autopopluating a number field 17 33
access 7 24
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now