Access and case-insensitivity

  • Thread starter Klaus Hebsgaard
  • Start date
K

Klaus Hebsgaard

Hello

I have an access database with a text field called node.
This field is indexed with the option "Yes (No Duplicates)".

Is it really not possible so have these two columns:

Type
type

Thank you in advance

Klaus Hebsgaard
 
T

Tom Wickerath

Hi Klaus,

It is not possible to have two fields in the same table named "Type" and
"type" (or any variation, such as "tYPe"). These names are considered the
same. Also, be aware that type is considered a reserved word in Access. You
should avoid using reserved words for anything that you assign a name to when
working in Access.

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


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello

I have an access database with a text field called node.
This field is indexed with the option "Yes (No Duplicates)".

Is it really not possible so have these two columns:

Type
type

Thank you in advance

Klaus Hebsgaard
 
K

Klaus Hebsgaard

Thank you for your quick answer :)

So does this mean that access in general is case insensitive?

Best regards

Klaus Hebsgaard
 
T

Tom Wickerath

Hi Klaus,

Yes, this is true if you are using the default JET database engine. Here
are two KB articles that deal with case sensitivity issues:

How to Return Case-Sensitive Matches in Queries
http://support.microsoft.com/?id=209674

When using MSDE and/or SQL Server with Access:
Unexpected Behavior with Case-Sensitive Objects
http://support.microsoft.com/?id=223202

Note that while the titles of both of these articles include "ACC2000", each
article likely applies to Access 2002 and 2003 as well.

Thank You for marking my response as an answer.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thank you for your quick answer :)

So does this mean that access in general is case insensitive?

Best regards

Klaus Hebsgaard
__________________________________________

:

Hi Klaus,

It is not possible to have two fields in the same table named "Type" and
"type" (or any variation, such as "tYPe"). These names are considered the
same. Also, be aware that type is considered a reserved word in Access. You
should avoid using reserved words for anything that you assign a name to when
working in Access.

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


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello

I have an access database with a text field called node.
This field is indexed with the option "Yes (No Duplicates)".

Is it really not possible so have these two columns:

Type
type

Thank you in advance
 
Top