MS Access Query
I have created a variable that is 22 digits long. For testing purposes I have written out this value on the asp.net page and it seems to work fine.
However when I update this value into a table in a MS Access database, I note that MS Access replaces the last eight digits with a zero.
Thus the value 7349927610203200716285 is written on the page , but in MS Access appears as 7349927610203200000000.
I have set the data types within the table in the database and within the asp.net code as double. I've also reduced the length of the variable to 16 digits long, but this issue still happens.
I'm using MS Access version 2002, but the actual database file is version 2000. Is this a bug or is MS Access working as it should ?