Solved

Linked Table in Access shows #Deleted

Posted on 2010-11-10
7
992 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
[X]
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
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

740 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