I am using ACCDB with SQL Server linked tables.
I have a table with a Numeric column, primary key and an identity column.
But when I link it to Access database, it is getting converted as Number and not Auto Number.
Any thoughts how to correct this?
An autonumber in Access is actually a long integer (int in SQL Server), with an additional property creating an autonumber. If your SQL Server data type is actually numeric, I don't see how Access can recognize it as an autonumber. When using Access as a front end to SQL Server, it is best to use data types that Access easily recognizes.
