I am having a hard time figuring out how to create an autonumber field in Access with vb.net. I am using code to create a database and tables, and plan to load imported text files into these tabels. But I'm still stuck on trying to create the autonumber field. Below is sample code of how i am creating the fields in the tables:
ADOXtable1.Name = "Points"
Col.Name = "Field1"
Col.Type = ADOX.DataTypeEnum.adDouble
Col = New ADOX.Column()