Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1002
  • Last Modified:

Linked Table in Access shows #Deleted

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
KnutsonBM
Asked:
KnutsonBM
  • 4
  • 2
3 Solutions
 
glangdonCommented:
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
 
KnutsonBMAuthor Commented:
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
 
MINDSUPERBCommented:
Try to delete the linked table and re-link it back.

Sincerely,
Ed
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
KnutsonBMAuthor Commented:
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
 
MINDSUPERBCommented:
have you tried the compact and repair?

Ed
0
 
KnutsonBMAuthor Commented:
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
 
KnutsonBMAuthor Commented:
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 your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now