Article ID: 125414
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Word 6.0 Standard Edition
- Microsoft Word 6.0a
- Microsoft Word 6.0c
- Microsoft Word 95 Standard Edition
- Microsoft Word 95a
- Microsoft Word 97 Standard Edition
- Microsoft Word 6.0 for Macintosh
- Microsoft Word 6.01 for Macintosh
- Microsoft Word 6.01 for Macintosh
This article was previously published under Q125414
SYMPTOMS
When you attempt to query a data source in which a data record contains an
apostrophe, you may receive one of the following error messages.
Word Data Source or Microsoft Excel Spreadsheet Using DDE or Converter (Windows and Macintosh)
Word could not parse your query options into a valid SQL String.
Microsoft Access Data Source Using ODBC (Windows Only)
Open Database Connectivity Error - 10014 in query expression ".
(Details button)
- ODBC Error: [Microsoft][ODBC Access Driver]10014 in query
expression ".
Error. Sql State: 37000.
Return Code: SQL_ERROR
Microsoft Access data Source Using DDE (Windows Only)
Word could not re-establish a DDE connection to Microsoft
Access to complete the current task.
FoxPro data source using ODBC (Windows)
Open Database Connectivity Error - Syntax Error.
(Details button)
- ODBC Error: [Microsoft][ODBC Single-Tier Driver]Syntax
Error.
Sql State: 37000.
Return Code: SQL_ERROR
- SELECT *FROM <database file> WHERE
(("<Fieldname>"='O'Neil'<<???>>>))
CAUSE
The Word for Windows SQL query engine does not recognize a "straight"
quotation mark or a "straight" apostrophe (as opposed to smart quotes, or
curly quotation marks) as a valid SQL or query string. The above errors do
not occur when using MS Query.
WORKAROUND
Method 1
Use smart quotes. To do this, follow these steps:
- If you have not created your Word data source, do the following:
- Turn on Smart Quotes. On the Tools menu, click AutoCorrect, then
click the "Change 'Straight Quotes' to 'Smart Quotes'"
option.
- Type in the data using smart quotes.
- Copy the data to the Clipboard.
- Start the query.
- In the Filter dialog box, paste the Clipboard contents into the
Compare To box.
- If you have an existing data source, use the AutoFormat command to
replace straight quotes with smart quotes:
- Open your data source.
- On the Format menu, click AutoFormat.
- Click the Options button. Under Replace, select the "Straight
Quotes with Smart Quotes" check box, clear any other check boxes,
and click OK.
- Click OK.
- Click Accept.
- Perform your query.
Method 2
Use MS Query. For applications like Fox Pro and Microsoft Access using
ODBC, you may have the option to use MS Query if you have Microsoft Excel
5.0 installed. Click the option to use MS Query instead of the internal
query engine in Word.
STATUS
We are researching this problem and will post new information here in the
Microsoft Knowledge Base as it becomes available.
Additional query words: merge data error message errmsg odbc sql query filter sort
Keywords: kberrmsg kbhowto kbbug kbinterop kbmerge KB125414