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()
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.