I have a SQL server database which needs to be linked to MS Access forms.
I have a table with one column as both Identity and is a also a primary key and is big int
But after linking the table , if i open the design window of table in MS access , it is converted as text
.
Why it is converting the Identity column to Text while linking.
Best Answer
Bigint is not a datatype supported by access. If you wanted the value to stay as a numeric value in access you would have to change the source column in the SQL server table to numeric(19,0).
https://msdn.microsoft.com/en-us/library/ms714540%28v=vs.85%29.aspx