I have a weird problem with C# and an access database. I have a table with a primary key set to autonumber. I allowed C# to create the tableadapter, binding srouce, navagator, etc.
The data navigatort has am ADD button. When I click on add, it will create a new recrod but it someitmes creates a primary key that has been used and deleted previosuly which of course access will not allow. Then I cannot save the record.
...