[AccessD] XP adp and SQL2005

David,
I often have trouble binding forms to views/stored procedures with more than
one table.
To get around this I select only from one table and add a number of
functions to get the data from the additional tables that I need.

I would create a test form based on the one table only to see if it also
creates the same problem. If that works then my function solution should
work.

Anita Smith

On Mon, Dec 22, 2008 at 1:30 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>