Very Computer

I have been developing a databaseapp. in DAO and it works well - except in
one situation.

I have an indexed primary and unique field in the database
When I use "data1.edit" and edit the record (not the indexed field) and save
it by using "data1.update", I get the errormessage no.3022, saying that I
can't duplicate an indexed, unique field.

The first record in the database works OK, but when I get to no. 2,3,etc, I
get the errormessage.

Kind regards
Carsten Jensen

Quote:>I get the errormessage no.3022, saying that I
>can't duplicate an indexed, unique field.

This means that a field in your table that has a unique index, and
your new record contains a value that already exists in the table in
the same field. Unfortunately, it does not say which field and you may
have inadvertently assigned a unique index to a field you shouldn't
have.

Check your table design very carefully -- the quickest way is View ->
Indexes in the table design window.

Check your data -- do you really have different values in each row?
Unfortunately, in Access "unique" is case-insensitive and there's
nothing you can do about that.

HTH

Tim F

--