Integer SQL Server to AutoNumber in Access

  • Thread starter Thread starter p-rat
  • Start date Start date
P

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.
 
hi,

p-rat said:
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?
Click to expand...
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 <--
 
Back
Top