I'm getting the dreaded #Delete in rows in a table that is linked from SQL server to Access. Primary Key is clearly defined. No nulls in that. Not using BigInt (googling suggests this may be a problem). It's just crazy. Here's my table design in SQL server... Please help!
PlanCode int Unchecked
TermDate nvarchar(30) Unchecked
IntRate nvarchar(30) Checked
Mortality nvarchar(30) Checked
MidYear nvarchar(30) Checked
Interpolation nvarchar(30) Checked
NormalForm nvarchar(30) Checked
ERPSupplement nvarchar(30) Checked
PlanReference nvarchar(255) Checked
PlanCode int Unchecked
TermDate nvarchar(30) Unchecked
IntRate nvarchar(30) Checked
Mortality nvarchar(30) Checked
MidYear nvarchar(30) Checked
Interpolation nvarchar(30) Checked
NormalForm nvarchar(30) Checked
ERPSupplement nvarchar(30) Checked
PlanReference nvarchar(255) Checked