Primary key autoincrement not working

Question

trying to do a primary key that is autoincrement. Here is the part for Thw ID in code.

Thanks for looking at this and helpping.

John

 

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileBinPath; (OleDbConnection connection = new OleDbConnection(connectionString)) Catalog catalog = new Catalog(); catalog.Create(connectionString); Table table = new Table(); table.Name = "Users"; DataColumn columnId = new DataColumn(); columnId.DataType = System.Type.GetType("System.Int32"); columnId.AutoIncrement = true; columnId.AutoIncrementSeed = 1; columnId.AutoIncrementStep = 1; columnId.AllowDBNull = false; Column nameCol = new Column(); nameCol.Name = "Name"; nameCol.Type = ADOX.DataTypeEnum.adVarWChar; nameCol.DefinedSize = 60; table.Columns.Append(columnId); table.Columns.Append(nameCol); catalog.Tables.Append(table); DataGridView1.DataSource = table;