Date:         Mon, 19 Jan 2004 22:17:47 -0800
Reply-To:     Doron Hadar <hadardo@BEZEQINT.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Doron Hadar <hadardo@BEZEQINT.NET>
Organization: http://groups.google.com
Subject:      ODBC driver and ACCESS query
Content-Type: text/plain; charset=ISO-8859-1

Hello.
This is a question from a newbie in the ODBC driver.
I want to build an MS-ACCESS application the uses tables from
different sources, some of the from SAS (ver 8.2). I've installed the
ODBC driver and accessed the SAS tables from MS-ACCESS 2000. It all
seemed fine till I wrote a query that combined a SAS table and an
inner ACCESS table. When I put a criteria on a variable in the ACCESS
table, I got an ODBC driver error. When I removed that criteria, the
query worked fine.
Any thoughts about it?
Thanks.
Doron Hadar.