No way to make Access case sensitive?

[Paul Blay]

I know about instr and such like functions but they are hardly a
smooth solution for large databases. Basically I am working with
somebody else's database that _is_ case (and hiragana vs
katakana)* sensitive.

* The two phonetic forms of Japanese writing, they are
somewhat analogous to capital vs lower case.

 

[Douglas J. Steele]

InStr is the only way to make Access case sensitive.

 

[Sylvain Lafontaine]

Another possibility would be to replace the backend with MSDE or SQL-Server
instead of JET/MDB. I don't know about hiragana vs katakana but
MSDE/SQL-Server give you a much greater control over case sensitivity than
JET:

http://www.databasejournal.com/features/mssql/article.php/3302341

 

[david epsom dot com dot au]

In Access, 'text' fields can have up to 255 characters, and
are not case sensitive. 'binary' fields can have up to 255/510
characters, and are case and character sensitive.

'Memo' fields can have up 2GB, and are not case sensitive.
'Binary large object' fields can have up to 2GB, and are
case and character sensitive.

Use 'ALTER TABLE' queries to add 'binary' fields to an Access
table.

Here is a KB article that mentions some of the options:

How To Perform a Case-Sensitive JOIN Through Microsoft Jet
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244693

(david)