TableID is to be autonumber - why? why wont it add 1

[ski2sun]

How do I make my sql table create an autonumber ID via a a field name called TableID. What should all the components/properties be? I am trying to append using Access interface, and cannot get a record to add at the end of the table....

 

[SQLSister]

What datatype is your field currently?

Access will not add records without their being some way to identify a record uniquely.

 

[ski2sun]

it is int, 4, prim key, but is not adding new records like an autonumber or anything like that...it is 'not nullable'. please help urgently..........

 

[Transcend]

Is the table in SQL or Access??

If it's in SQL you need to go into the design of the table and click on the field you want to act like an autonumber. Down the bottom of the design page you will have to set
Identity = yes
Identity seed = 1

If it's an Access table you need to define it as an Autonumber.

Thanks and good luck!

Transcend

 

[ski2sun]

thanks so much transcend..exactly what i needed...have a good day