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.
Please read the manual, dates are covered in section 7.3.2 .
----- 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
> > parameter from the column. Second, I didn't notice the first time, but
> > also need a TIMESTAMP(14) in your table.
> Can I name this column anything I want or must it specifically be