Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Linked Table in Access shows #Deleted

Posted on 2010-11-10
7
Medium Priority
?
1,001 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 668 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 1332 total points
ID: 34102495
Try to delete the linked table and re-link it back.

Sincerely,
Ed
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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 1332 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

971 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