Re: BEST odbc driver for windows MS Access

Very helpful, thanks!

~K.

Richard Broersma Jr wrote:

If ANYONE out there has any experience with this, 
from any MS application using VBA, I would appreciate hearing from 
them...and any references to other message lists are welcome too - 
thanks for the pointer to the odbcng list, Richard.   

If you install the MSI version of the driver, it will also install odbc help documentation in your
windows start menu.  There is an example of how to connect using vb.  Also if you search the odbc
mailing list archieves you will find many other examples that show how to do this.  There are some
important "lessons learned"  about linking tables via ms-acces also documented in the archieves.

to search odbc list archieves check out the following link:
http://archives.postgresql.org/pgsql-odbc/

one of the many sample ado connection scripts:
http://archives.postgresql.org/pgsql-odbc/2006-11/msg00019.php

Here is one such bit of advice:
http://archives.postgresql.org/pgsql-odbc/2006-10/msg00022.php

Regards,
Richard Broersma Jr. 

-- 

Kelly Close
Hydrosphere Resource Consultants, Inc.
1002 Walnut, Ste 200
Boulder, CO  80302

(303) 443-7839
http://www.hydrosphere.com