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