I am getting a [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
The application is using a single access table and the from clause is simply from [table name].
I have cut and pasted the query that appears in the error message into access and it works fine.
Here is the query as shown by the error message:
select [Site ID], [Record Updated], [Site Name], [Site Since], [Site Visit], [Site Website], [Information In File], [Brochure], [Program Description], [Site Evaluation], [Flexible Practicum Hours], [Activity Codes], [Type of Setting], [Practicum(s) Offered: PsyD Assessment], [Practicum(s) Offered: PsyD Therapy], [Practicum(s) Offered: PsyD Advanced], [Practicum(s) Offered: MA Counseling], [MA Marriage and Family], [MA Substance Abuse Counseling], [Practicum(s) Offered: MA Counseling and Art Therapy], [Practicum(s) Offered: MA Counseling & Organizational Psychology], [Practicum(s) Offered: MA Gerontological Psychology], [Certificate in Art Therapy], [Practicum(s) Offered: Certificate in Adlerian Psychotherapy], [Practicum(s) Offered: Certificate in Clinical Hypnosis], [Practicum(s) Offered: Certificate in Clinical Neuropsychology], [Practicum(s) Offered: Certificate in Group Psychotherapy], [Practicum(s) Offered: Certificate in Marriage & Family Therapy], [Practicum(s) Offered: Certificate in Substance Abuse Counseling], [Distance from Chicago Campus], [Start Date], [End Date], [Number of Positions] From [Practicum Sites]
Any idea what would cause this?
Thanks for your help,
Bruce