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