how to create a access table having autonumber type with sql?

[bcs]

hi,
field type of autonumber can not be created with sql,why?is autonumber a data type like int,text ect.?but int or text field can be created

 

[testmud]

Your means is use sql command in access to created autonumber data type ?

Or use mysql database ?

 

[bcs]

create MS access 2000 table

 

[bcs]

Thank you!Testmud.I get it.the autonumber type is "counter" .