Handle Autoinc fields
Microsoft Access MDB and ACCDB database files viewer and editor.
Brought to you by:
ecalogiuri
When I try to add a record to a table with an Autoinc field I'm not able to do this.
Neither using Import nor by adding (+) a new record in the table.
The new record is created but the value of the Autoinc field is not valid (empty) and I can also not edit it.
Trying to save the table gives an error message (German) "Nicht genügend Schlüsselfeldinformationen zum Aktualisieren." = " Not enough key field information to update."
The SQL for creating an Autoinc field is shown as
Create Table Parameter (
ID COUNTER,
I wonder if it is not possible to add a record to a table with an Autoinc field or if I just don't know how to do it.