Integer SQL Server to AutoNumber in Access

[p-rat]

I'm trying to make a TableID and autonumber in Access. This is on a
linked table to SQL Server backend. The field is datatype integer in
SQL Server, but I can't get this field to become an autonumber in
Access. What kind of silly mistake am I making here? Thanks for any
help you can provide.

 

[Stefan Hoffmann]

hi,

I'm trying to make a TableID and autonumber in Access. This is on a
linked table to SQL Server backend. The field is datatype integer in
SQL Server, but I can't get this field to become an autonumber in
Access. What kind of silly mistake am I making here?

You need to create the correct column on the SQL Server side, e.g.

CREATE TABLE test
(
ID INT NOT NULL PRIMARY KEY IDENTITY(1,1),
Payload VARCHAR(50) NOT NULL
)

Take a look for Identity Specification in the property editor when
creating/modifiying a table using SQL Server Management Studio.


mfG
--> stefan <--