Created a table with datatype bigint in sql server 2005.
When I tried to link this table and view it through access,the table content is showing as 'deleted' text. If I change it to some other data type like decimal,it is showing correctly in access.
As per my knowledge, there is restriction related to tables without primary key,but,the table is having primary key field.
What should be done to see the sql server table correctly in access?