Can't save a record again

  • Thread starter Thread starter rob willaar
  • Start date Start date
R

rob willaar

Hi All,

I add a new row to a datatable and refresh the dataset. The data is stored.
When i edit the row again and refresh the dataset again i get an error
telling me the record was edited.

probably the database is setting defaultvalues but i have no default values
set (i think)!

Could someone tell me how to set the properties for the fields in a Jet
(access) database?

By the way:
The checkbox 'Refresh the dataset' in the data adaptor advanced settings is
disabled.
If i uncheck 'use optimistic concurrency' the error does not occur but i
don't want to do that.

with kind regards,

rob
 
Rob,

When you are using autokey, then AFAIK is the only thing you can do after an
update is clean your datatable and fill it again, with what you get as well
all changes from other users.

Cor
 
Back
Top