Is "Date" a reserved keyword of Microsoft Access?

  • Thread starter Thread starter sic
  • Start date Start date
S

sic

I can't insert a record into a table with the field name date and type date
by ODBC driver, but I can after I changed the field name from date to
anything else. So is it because date is a keyword of Access or any other
reasons?
 
Date is a reserved word but you can use it as a name by enclosed it with
delimiters [], as in [Date]. However, I won't recommend this practice.

S. L.
 
I agree with Sylvain that you should avoid using reserved words. Here are some articles worth
reading:

Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335

List of reserved words in Jet 4.0
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp


Tom
_________________________________

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> wrote in message

Date is a reserved word but you can use it as a name by enclosed it with
delimiters [], as in [Date]. However, I won't recommend this practice.

S. L.

_________________________________


I can't insert a record into a table with the field name date and type date
by ODBC driver, but I can after I changed the field name from date to
anything else. So is it because date is a keyword of Access or any other
reasons?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top