>I've just created a Database with a few tables, all with numeric primary keys:
>
>
>I go in , browse a table, seelct option to add a record, and leave primary key as zero.
>
>I then try to add another record...it wont let me saying 'Uniqueness of index XXXXXX violated.
>
>
>I reckon the system is trying to assign a primary key of 0, but is there a way around this ?
>
The way is natural: do not leave primary key as 0. Primary key is usually auto-generated sequential number.
Edward Pikman
Independent Consultant