[PLUG] PostgreSQL non-DSN connection from Access 2000

[Lee Marzke <lee@marzke.net>]

Does anyone have experience using PostgreSQL as a backend for MsAccess front
end databases.  This provides an easy migration for existing MsAccess 
databases, and
it works over the WAN  unlike file based MsAccess databases.

I need to connect/refresh ODBC tables in PostgreSQL 7.4 from Access 
2000.  Since this
application will be distributed to many users,  I need to prompt for 
username/password, and
compose a connect string without using a DSN.

I had this working with Access 97 and PostgreSQL 7.2, but since then the 
Access code
has broken with the upgrade.

Thanks,

Lee Marzke
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug