You can call the column anything you want, as long as it is not a reserved
word. TIMESTAMP is a data type. For compatibility, you must use a
TIMESTAMP(14) i.e. a column of TIMESTAMP type with a presentation length of
14. A TIMESTAMP(14) looks like this 'YYYYMMDDHHMMSS' and is readily
recognized in ACCESS.
e.g.
myTimestamp TIMESTAMP(14),
Please read the manual, dates are covered in section 7.3.2 .
Pat...
----- Original Message -----
From: Sanford Carr <spcarr@stripped>
To: Patrick Sherrill <patrick@stripped>
Sent: Thursday, November 04, 1999 4:11 PM
Subject: Re: Access 2000 - user already updating record
> On 4 Nov 99, at 15:48, Patrick Sherrill wrote:
>
> > Two things, first you must set a default date as I described if you are
> > going to use 'NOT NULL' and ODBC or JET (ACCESS) or remove the 'NOT
NULL'
> > parameter from the column. Second, I didn't notice the first time, but
you
> > also need a TIMESTAMP(14) in your table.
>
> Can I name this column anything I want or must it specifically be
> TIMESTAMP?
>
> Sanford
>
