Wrong data type while using linked tables in MS Access
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