Microsoft KB Archive/102523: Difference between revisions
m (Text replacement - """ to """) |
m (Text replacement - ">" to ">") |
||
(One intermediate revision by the same user not shown) | |||
Line 42: | Line 42: | ||
<li>Switch to Design view. From the View menu, choose SQL.</li> | <li>Switch to Design view. From the View menu, choose SQL.</li> | ||
<li><p>After the FROM clause, "FROM NEWCUST", type the following:</p> | <li><p>After the FROM clause, "FROM NEWCUST", type the following:</p> | ||
<blockquote><pre> IN " | <blockquote><pre> IN "<drive:\path>" "dBASE IV;"</pre></blockquote> | ||
<p>where | <p>where <drive:\path> is the drive and directory in which you installed Microsoft Access.</p></li> | ||
<li>Choose OK to close the SQL dialog box, then choose OK again.</li> | <li>Choose OK to close the SQL dialog box, then choose OK again.</li> | ||
<li>Run the query.</li> | <li>Run the query.</li> |
Latest revision as of 10:16, 20 July 2020
PRA: Invalid Characters Added to IN Clause ArgumentsArticle ID: Q102523
SYMPTOMS
CAUSE
RESOLUTION
STATUS
MORE INFORMATION
You must choose Cancel, or correct the IN clause by removing the square brackets from the external database name.
REFERENCES
|
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.
Additional reference words: 1.10
KBCategory: kbusage kberrmsg
KBSubcategory: ObcOthr