SQL Server Numeric with Identity not converting to Auto Number in MS Access using linked tables

Question

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?

Answer 1

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.