Solved

Linked Table in Access shows #Deleted

Posted on 2010-11-10
7
990 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

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

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…
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…
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.
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.

776 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