Hi Lynn, well I found out what the problem was. I was getting crappy information appearing in my linked tables for some reason. When I do a import of a table (eg BKSOHSER) then I get no duplicates and the correct information appears that corresponds with Maintain Database information, but when I do Link Tables then I get duplicates.  
Thanks for your patience.
Do you have any idea why Access import displays the correct information but the link tables does not?

Thanks Lorne. I see what I was doing wrong I wasn't choosing a unique field for my primary key on the link.  
How dumb do I have to be! Thanks all problems now solved.