| 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.
|
