Solved

Linked Table in Access shows #Deleted

Posted on 2010-11-10
7
989 Views
Last Modified: 2013-11-29
I have a table in Access linked to a SQL table, but it is bringing back #Deleted in every field.  What would cause this and how do i fix it?
0
Comment
Question by:KnutsonBM
  • 4
  • 2
7 Comments
 

Accepted Solution

by:
glangdon earned 167 total points
ID: 34101416
The records have probably been deleted by another program/process whist you had the table open in MS Access.  This is why the error will be generated.   The solution is to either rollback the SQL transaction to recover the records or type in more data.  Close and re-open the table (after commit/rollback) in order to get rid of the #Deleted record status.
0
 
LVL 6

Author Comment

by:KnutsonBM
ID: 34101430
the records are still there, when i 'import' the table instead of linking it, you can see all of the records....................., but i need to have the table linked because the sql table is constantly being updated by hundreds of other users and i need to be able to pull that data..................
0
 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 333 total points
ID: 34102495
Try to delete the linked table and re-link it back.

Sincerely,
Ed
0
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.

 
LVL 6

Author Comment

by:KnutsonBM
ID: 34102525
done it twice and having the same problem.  One other thing to note is each of these tables has a few hundred thousand entries, is that causing the problem?

-Brandon
0
 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 333 total points
ID: 34102674
have you tried the compact and repair?

Ed
0
 
LVL 6

Author Comment

by:KnutsonBM
ID: 34102713
i have not, and i am a little weary about doing it in the DB i am working in because somebody else manages it, but i have tried linking the tables in 3 other access databases and it acts the same way.......

-Brandon
0
 
LVL 6

Author Comment

by:KnutsonBM
ID: 34102891
So it turns out there is some issue with the SQL table, got ahold of one of the DB Analysts here, they don't know what the problem is with it, but they created a workaround that does what i need it to.....................very strange..............
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

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

22 Experts available now in Live!

Get 1:1 Help Now