Kbase P5767: MS Access SQL Select Statement fails with syntax error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/15/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
Windows 32 Intel
SYMPTOM(s):
Using MS-ACCESS as front-end application
Using Progress SQL-92 access to database
SELECT * FROM PUB.Acct;
[MERANT][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)
CAUSE:
Ending SQL statement with a semi colon (;) causes error with MS-Access.
FIX:
Do not place any form of punctuation at the end of Select statement when using MS-ACCESS.
Remove the semi colon (;).