Integer SQL Server to AutoNumber in Access p-rat <osupratt[ at ]yahoo.com> 12/8/2008 4:21:35 PM 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.

Re: Integer SQL Server to AutoNumber in Access Stefan Hoffmann <ste5an[ at ]ste5an.de> 12/8/2008 4:30:57 PM hi, p-rat wrote: [Quoted Text] > 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 <--