Solved

Access 2010 Query is Returning "Record is Deleted"

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

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 125 total points (awarded by participants)
Comment Utility
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)
Comment Utility
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)
Comment Utility
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 18
Comment Utility
yes -- and I would suggest doing it 3 times. Be sure to back it up before C/R.
0
 
LVL 18
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…

744 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

17 Experts available now in Live!

Get 1:1 Help Now