[dba-SQLServer] XP adp and SQL2005

		Depending on the GUI for this, the ODBC driver uses the Timestamp column to determine if a change has been made.

You cannot include the Timestamp column in the insert statement. You need to either rewrite the INSERT or, do not
bind the timestamp column when using it in the GUI. So, in your case, do not include the timestamp column in the
control on the ADP form.

----------------------------------------

		 > > Date: Mon, 22 Dec 2008 15:30:28 +1300
> > To: accessd at databaseadvisors.com; dba-SQLServer at databaseadvisors.com
> > From: newsgrps at dalyn.co.nz
> > Subject: [dba-SQLServer] XP adp and SQL2005
> >
> > 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
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 3
>_________________________________________________________________
>Send e-mail faster without improving your typing skills.
>http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com

------------------------------

Message: 2
Date: Mon, 22 Dec 2008 23:38:24 -0600
From: "John Bartow" 
Subject: [dba-SQLServer] Happy Hanukkah
To: , "_DBA-Access"
, "_DBA-OT"
, "_DBA-Tech"
, 
Message-ID: <008e01c964c0$ac552750$04ff75f0$@net>
Content-Type: text/plain; charset="us-ascii"

A Happy Hanukkah from the Database Advisors Board of Directors.

Here's a little JibJab fun:

http://www.winhaven.net/misc/HappyHanukkahDBA.html

------------------------------

Message: 3
Date: Tue, 23 Dec 2008 05:11:04 -0500
From: "Arthur Fuller" 
Subject: [dba-SQLServer] Gmai is acting funny
To: "Discussion concerning MS SQL Server"

Message-ID:
<29f585dd0812230211h1af7fb93s21c879706e46e3d4 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

i have noticed lately that not everything I send shows up in the Sent Mail
folder. And yet I get replies to these. Any idea what's going on?

Happy holiday season everyone,
Arthur

------------------------------

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver

End of dba-SQLServer Digest, Vol 70, Issue 8
********************************************