Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access 2010 Query is Returning "Record is Deleted"

Posted on 2016-09-23
5
23 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 35

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

839 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