Reserved Words Case Sensitive?

[PaulJR]

Microsoft application note 286335 (List of reserved words in Access....) gives a list of reserved words that we should avoid. Does anyone know for certain if these reserved words are case sensitive?

 

[Banana]

Considering that the behavior is to use same capitalization for any keywords, I would have to say it won't matter if you type in NAME, NAme, or name- it will be all same as Name to Access and still cause problem.

 

[Rabbie]

Microsoft application note 286335 (List of reserved words in Access....) gives a list of reserved words that we should avoid. Does anyone know for certain if these reserved words are case sensitive?

In most cases these are not case sensitive. In any case it would cause confusion if you had two different names only differing by capitalisation. remember someone else may have to maintain your DB in the future.

 

[Banana]

Rabbie, believe it or not, it seems to be fairly common for C-variants folks to use names differing in only capitalization (e.g. Name as a base class, and name as a actual object of the Name class).

Not that I don't disagree with you- it'd be confusing as hell.

 

[Rabbie]

Rabbie, believe it or not, it seems to be fairly common for C-variants folks to use names differing in only capitalization (e.g. Name as a base class, and name as a actual object of the Name class).

Not that I don't disagree with you- it'd be confusing as hell.

I guess its what you're used to

 

[boblarson]

So the big thing out of this is that Access isn't case-sensitive - so don't try to use the same name for something that is an Access Reserved Word.
http://support.microsoft.com/kb/q286335/

 

[PaulJR]

Thank you for all your responses, I had a reserved name that was used throughout my database (only differing by capitalisation). To play safe I have changed the name, and this being my first Access project I'm happy its all still working okay