MS Access field called "date"

I have a field in my access database called "date" ( because the client
wants it that way (and because Access allows me to create a field called
date(the "date" field is of type text in this case))).

I get a syntax error with this ->

INSERT INTO FecEmail
(Title,Organization,Description,Facilitator,Date,Time,Place, Cost,Childcare,C
ontact,Type,phoneNumber,email) VALUES( then I put in all the appropriate
values )

I understand the reasoning for not allowing a reserved word being used as a
field name in an sql statement, but Access allows me to name a field "date".
So there must be a way to populate it from an asp page .

Does anyone have any ideas on how I can insert data into my "date" field
from asp, using "Server.CreateObject("ADODB.Connection");"

Any help will be greatly appreciated.

sg.

--
Stephen Gray
srgray99@sympatico.ca

Re: MS Access field called "date"

Use [date] - note square brackets. Time might be troublesome also.

Why does your client care what the columns are named? Is he some real estate
agent that worked up some nifty application in Access and now considers
himself a programmer?

Bob Lehmann

"Stephen Gray" wrote in message
news:uiEF0eFhGHA.4848@TK2MSFTNGP04.phx.gbl...
>
> I have a field in my access database called "date" ( because the client
> wants it that way (and because Access allows me to create a field called
> date(the "date" field is of type text in this case))).
>
> I get a syntax error with this ->
>
> INSERT INTO FecEmail
>
(Title,Organization,Description,Facilitator,Date,Time,Place, Cost,Childcare,C
> ontact,Type,phoneNumber,email) VALUES( then I put in all the appropriate
> values )
>
> I understand the reasoning for not allowing a reserved word being used as
a
> field name in an sql statement, but Access allows me to name a field
"date".
> So there must be a way to populate it from an asp page .
>
> Does anyone have any ideas on how I can insert data into my "date" field
> from asp, using "Server.CreateObject("ADODB.Connection");"
>
> Any help will be greatly appreciated.
>
> sg.
>
> --
> Stephen Gray
> srgray99@sympatico.ca
>
>

Re: MS Access field called "date"

"Bob Lehmann" wrote in message
news:exQeGoFhGHA.4304@TK2MSFTNGP05.phx.gbl...
> Use [date] - note square brackets. Time might be troublesome also.
>
> Why does your client care what the columns are named? Is he some real
> estate
> agent that worked up some nifty application in Access and now considers
> himself a programmer?
>
> Bob Lehmann
>
> "Stephen Gray" wrote in message
> news:uiEF0eFhGHA.4848@TK2MSFTNGP04.phx.gbl...
>>
>> I have a field in my access database called "date" ( because the client
>> wants it that way (and because Access allows me to create a field called
>> date(the "date" field is of type text in this case))).
>>
>> I get a syntax error with this ->
>>
>> INSERT INTO FecEmail
>>
> (Title,Organization,Description,Facilitator,Date,Time,Place, Cost,Childcare,C
>> ontact,Type,phoneNumber,email) VALUES( then I put in all the appropriate
>> values )
>>
>> I understand the reasoning for not allowing a reserved word being used as
> a
>> field name in an sql statement, but Access allows me to name a field
> "date".
>> So there must be a way to populate it from an asp page .
>>
>> Does anyone have any ideas on how I can insert data into my "date" field
>> from asp, using "Server.CreateObject("ADODB.Connection");"
>>
>> Any help will be greatly appreciated.
>>
>> sg.
>>
>> --
>> Stephen Gray
>> srgray99@sympatico.ca
>>
>>


I recommend you dont use DATE as I have encountered peculiar problems with
it in the past.

Re: MS Access field called "date"

> I recommend you dont use DATE

I recommend it too. But I don't have a PHB telling me what to the name the
columns like the OP does.

Bob Lehmann

"PW" wrote in message
news:eSmzOtFhGHA.4776@TK2MSFTNGP05.phx.gbl...
>
> "Bob Lehmann" wrote in message
> news:exQeGoFhGHA.4304@TK2MSFTNGP05.phx.gbl...
> > Use [date] - note square brackets. Time might be troublesome also.
> >
> > Why does your client care what the columns are named? Is he some real
> > estate
> > agent that worked up some nifty application in Access and now considers
> > himself a programmer?
> >
> > Bob Lehmann
> >
> > "Stephen Gray" wrote in message
> > news:uiEF0eFhGHA.4848@TK2MSFTNGP04.phx.gbl...
> >>
> >> I have a field in my access database called "date" ( because the client
> >> wants it that way (and because Access allows me to create a field
called
> >> date(the "date" field is of type text in this case))).
> >>
> >> I get a syntax error with this ->
> >>
> >> INSERT INTO FecEmail
> >>
> >
(Title,Organization,Description,Facilitator,Date,Time,Place, Cost,Childcare,C
> >> ontact,Type,phoneNumber,email) VALUES( then I put in all the
appropriate
> >> values )
> >>
> >> I understand the reasoning for not allowing a reserved word being used
as
> > a
> >> field name in an sql statement, but Access allows me to name a field
> > "date".
> >> So there must be a way to populate it from an asp page .
> >>
> >> Does anyone have any ideas on how I can insert data into my "date"
field
> >> from asp, using "Server.CreateObject("ADODB.Connection");"
> >>
> >> Any help will be greatly appreciated.
> >>
> >> sg.
> >>
> >> --
> >> Stephen Gray
> >> srgray99@sympatico.ca
> >>
> >>
>
>
> I recommend you dont use DATE as I have encountered peculiar problems with
> it in the past.
>
>
>

Re: MS Access field called "date"

Stephen Gray wrote:
> I understand the reasoning for not allowing a reserved word being
> used as a field name in an sql statement, but Access allows me to
> name a field "date". So there must be a way to populate it from an
> asp page .

There is, but I don't understand the logic that lead to this statement.
"ASP" was the name of a snake when the Jet engine and Access were developed.

>
> Does anyone have any ideas on how I can insert data into my "date"
> field from asp, using "Server.CreateObject("ADODB.Connection");"
>
See Bob's reply.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: MS Access field called "date"

not that it matters... but i always use idate instead of date

"Bob Barrows [MVP]" wrote in message
news:O26dXJKhGHA.1864@TK2MSFTNGP02.phx.gbl...
> Stephen Gray wrote:
>> I understand the reasoning for not allowing a reserved word being
>> used as a field name in an sql statement, but Access allows me to
>> name a field "date". So there must be a way to populate it from an
>> asp page .
>
> There is, but I don't understand the logic that lead to this statement.
> "ASP" was the name of a snake when the Jet engine and Access were
> developed.
>
>>
>> Does anyone have any ideas on how I can insert data into my "date"
>> field from asp, using "Server.CreateObject("ADODB.Connection");"
>>
> See Bob's reply.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>