SQL Server带有身份的数字无法在使用链接表的MS Access中转换为自动编号 [英] SQL Server Numeric with Identity not converting to Auto Number in MS Access using linked tables

问题描述

我正在将ACCDB与SQL Server链接表一起使用.

I am using ACCDB with SQL Server linked tables.

我有一个带有Numeric列，主键和标识列的表.

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

但是当我将其链接到Access数据库时，它将被转换为Number而不是Auto Number.

But when I link it to Access database, it is getting converted as Number and not Auto Number.

有什么想法要纠正这个问题吗?

Any thoughts how to correct this?

推荐答案

Access中的自动编号实际上是一个长整数(在SQL Server中为int)，带有一个附加属性可创建一个自动编号.如果您的SQL Server数据类型实际上是数字，则看不到Access如何将其识别为自动编号.将Access用作SQL Server的前端时，最好使用Access容易识别的数据类型.

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.

这篇关于SQL Server带有身份的数字无法在使用链接表的MS Access中转换为自动编号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！