#Delete in tables? (1 Viewer)

CedarTree

Registered User.
Local time
Today, 11:27
Joined
Mar 2, 2018
Messages
404
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
 

CedarTree

Registered User.
Local time
Today, 11:27
Joined
Mar 2, 2018
Messages
404
Ha! I think I figured it out. The person filling in the table was using the greater than or equal (single) character rather than >=

The field in question was a text field). So it seems Access freaked out about that character. Lesson learned.
 
Last edited:

isladogs

MVP / VIP
Local time
Today, 15:27
Joined
Jan 14, 2017
Messages
18,186
Ha! I think I figured it out. The person filling in the table was using the greater than or equal (single) character rather than >=. So it seems Access freaked out about that character. Lesson learned.

How did they manage that - its not a standard keyboard character!

The latest version of Access 2016 using office 365 CAN handle BigInt. Any Access 2016 versions prior to about last August or previous versions can't do so.
 

CedarTree

Registered User.
Local time
Today, 11:27
Joined
Mar 2, 2018
Messages
404
It was a copy/paste from Excel and Excel allows that character of course.
 

Users who are viewing this thread

Top Bottom