Tag Archives: primary key

Can’t delete records in SQL Server table from Access

Issue: Table must have a Primary key (or at least a unique index). Resolution: When creating the link to the SQL Server table, and Access prompts for index, this isn’t sufficient. The index must be created on the SQL Server … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , | Leave a comment