[dba-SQLServer] XP adp and SQL2005

David Emerson newsgrps at dalyn.co.nz
Sun Dec 21 20:30:28 CST 2008


I have a view being used for a subform.  It combines 4 tables but 
only one has data which is changed.  It is a 'many' table.  All of 
the tables have primary keys.

The table being edited has a timestamp column created when the 
database was upsized from Access XP to SQL2000.  The database was 
then scripted and created on SQL2005.

When I try to add a record I get the following error:

Cannot insert an explicit value into a timestamp column.  Use INSERT 
with a column list to exclude the timestamp column, or insert a DEFAULT.

Because I am using a bound form I do not have the option of a column 
list (I don't think).  If I remove the timestamp field from the view 
then I don't even get an option to add a record.  With the timestamp 
included I can add the data for a new record, but just can't save it.

I am not sure what is meant in the error message by "Insert a 
default".  I tried adding a textbox to the form for the timestamp 
field and put DEFAULT in the default property but this didn't work.

Does anyone have any suggestions?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand 




More information about the dba-SQLServer mailing list