On Monday, July 19, 1999 12:58 PM, Arnie Roberts [SMTP:[EMAIL PROTECTED]] wrote:
> On Tuesday, July 20, 1999 3:44 AM, Mike McCauley [SMTP:[EMAIL PROTECTED]] wrote:
> > Hi Arnie,
> > what is the data tpe of your TimeStamp column in Access?
> >
> > I have just been experimenting with an Access database where the Timestamp
> > column was a 'Number' (ie an int in SQL talk) with no problem .
> >
> > Cheers.
> >
> Hi Mike,
>
> I've tried Number and Text with no success. I will scratch the database and
>re-create with
> TimeStamp field as Number and let you know.
>
> Thanks
>
> Arnie
>
>
>
I've just figured this out.
Re-creating the table didn't work!
In desperation I renamed the field title to StartTime and it worked!!!
Presumably "TimeStamp" is a reserved name in Access and I was lucky enough to choose
it.
Mike did you use TimeStamp or some other name?
Thanks for your help.
Arnie
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
