Windows ODBC

[Mark Wieder]

Bob-

Sunday, January 11, 2004, 9:41:15 AM, you wrote:

K> Using the Microsoft Access 2003 ODBC driver I can get as far as
K> connecting within the "Database Query Builder", but when I go to
K> the "Record Set" table there aren't any tables in the "Table"
K> drop-down.  Note that I CAN successfully use this ODBC Driver
K> within other programs, such as R:Base.

It's definitely a bug with the Query Builder. You'll find the same
thing happening with SQL Server. Skip the Database Query Builder and
use the revdb commands. They work just fine even if the Query Builder
can't come up with a list of tables. Also, you'll find that if you
enter valid SQL into the query builder it *will* work, it just won't
give you any help getting there.

-- 
-Mark Wieder
 mwieder at ahsoftware.net