ACC: Case Sensitivity in Queries Differs with Linked Tables
ID: Q100921
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SUMMARY
Novice: Requires knowledge of the user interface on single-user computers.
When you query on a linked (attached) table, the criteria becomes case
sensitive if the linked table is in a format other than a Microsoft Access
table, such as dBASE, Paradox, ODBC, and so on.
MORE INFORMATION
There are several ways to prevent case sensitivity in criteria when you
query on linked tables:
Steps to Reproduce Behavior
NOTE: If you are using Microsoft Access 2.0 or earlier you can skip
steps 1 and 2. The Newcust.dbf sample dBASE file is supplied with
Microsoft Access 1.x and 2.0.
- Open the sample database Northwind.mdb.
- Export the Customers table to a dBase V file named Newcust.dbf.
- Create a new Microsoft Access database.
- Create a link (or attachment in Microsoft Access 2.0 or earlier) to
the dBASE V file Newcust.dbf.
- Create a new query based on the linked Newcust table. Name this query
QueryTest.
- Drag all the Newcust table fields to the query grid.
- Make the following change to the CITY column:
Query: QueryTest
---------------------------------
FieldName: CITY
Show: True
First Criteria Line: Like "s*"
Note that the "s" is lowercase.
- Run the query. Note that the result is an empty recordset.
- Import the same dBASE table.
- Create a new query using the newly imported table and, after dragging
all of the fields to the query grid, save the query as QueryTest2.
- Add the same criteria to the CITY column as you used in Step 4.
- Run the query. You now receive all the records where the name
of the city begins with the letter "S" or "s."
REFERENCES
For more information about criteria in queries, search the Help Index for
"Criteria," or ask the Microsoft Access 97 Office Assistant.
For more information about UCase() function, search the Help Index for
"UCase, UCase$ Function."
Additional query words:
isam paradox btrieve fox pro
Keywords : kbusage QryOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbinfo