ms access - timestamp column doesn't update in sql server -
i moved access database backend sql server , still using access frontend. getting overwrite errors when entering records. found solution (thank you) add timestamp (rowversion) column table did. however, timestamp column not populate new records nor did update on existing records. appreciated.
the timestamp field sql server's use only. access neither reads or writes it, odbc driver does. sole purpose odbc driver see, before updating record, if has changed on server since last reading driver. if hasn't, update safe - if has, record re-read , update cancelled.
Comments
Post a Comment