SQLTeam.com | Weblogs | Forums

Sql server table with big int data type not displaying in acess


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?



did you Google it? I found this on the first try:

ACC2000: Linked SQL Server Table That Uses BigInt Data Type as Primary Key Displays #Deleted