|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>|
|Subject: ||ODBC driver and ACCESS query|
|Content-Type: ||text/plain; charset=ISO-8859-1|
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?