[AccessD] XP adp and SQL2005

Thanks Anita.  I made the change to a sproc and was still able to 
combine most of the tables.  Now it works.

Regards

David

At 23/12/2008, you wrote:
>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
> >
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com