Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily.

Executing this query in SQL returns results such as: Now if you drop the view from your data model and re-add it, EF will pick up the real primary key column that is labeled NID and your LINQ ...