Geek Answers Handbook

Identified SQL Server number not converted to automatic number in MS Access using linked tables

I am using ACCDB with SQL Server related tables.

I have a table with a Numeric column, a primary key and an identity column.

But when I link it to the Access database, it converts as Number , not Auto Number .

Any thoughts how to fix this?

0
sql-server type-conversion ms-access linked-tables
source share
1 answer

The stand-alone number in Access is actually a long integer (int in SQL Server), with the additional property of creating autonumber. If your SQL Server data type is actually numeric, I don’t see how Access can recognize it as a standalone. When using Access as the front end of SQL Server, it is best to use data types that Access easily recognizes.

0
source share

More articles:


All Articles