Is "Date" a reserved keyword of Microsoft Access?

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?
 
S

Sylvain Lafontaine

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.
 
T

Tom Wickerath

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?
 
Top