Linked SQL Server Table Duplicates First Row When Opened in Access

Question

Good Afternoon,

I have an SQL Server table that is linked to Microsoft Access. When I right click to simply open the entire table in Access, it duplicates the first row many, many times. However, when I do a query to obtain the first row from the linked table it returns the correct row one time.

I wonder if in the process of linking the table I may have made a mistake?

Thank you for taking the time to read and respond to this question.

Al

Answer 1

Hi @Al C ,

This is a SQL Server forum. Since I'm not very familiar with Access, I found this article for you:
https://www.accessrepairnrecovery.com/blog/removing-duplicate-records-in-microsoft-access

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Good Morning,

I have been submitting comments in the "Have any additional feedback? We'd love to hear it" space thinking that I was responding to you or others on the website. Just in case you did not receive my last message, I would like you to know that I followed up on your suggestion by posing the problem to the Microsoft Community in the hope of getting an answer from the "Access side."

In the meantime, however, I want to thank you for the Profiler suggestions. I will try that later this morning.

I do want you to know that I consider it a privilege to engage with people like you who are willing to share their knowledge and time.

Thank you.

Al

Answer 3

So there is one thing I can suggest from SQL Server side of things: Use Profiler to see what statements Access sends to SQL Server. That could give a clue of what is going on.