Re: @#$%^& Access and PostgreSQL

Hello,

Firstly, beleive me, Access linked to Postgresql through ODBC works really well. The driver works fine, I'm using it every day, several clients too.

How do you "query and fiddle with the data in Access"? You have to use a ***linked ODBC table***, and in this case, updates are transparent. You simply modify the data, and the updates are generated for you. Is that what you are trying to do?

Philippe

-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Roderick A. Anderson
Envoyé : mardi, 15. juin 2004 01:50
À : pgsql-odbc(at)postgresql(dot)org
Objet : [ODBC] @#$%^& Access and PostgreSQL

I have spent two days now trying to get MS Access to play with PostgreSQL.
Searched the archives of this list and Google'd myself crazy but either I'm the only one having problems with this :-) or I haven't figured out the right keywords to search.

Short story. Pg 7.2 running on a Linux box. MS Access 2000 on WinXP Pro.
I can query and fiddle with the data in Access but I haven't figured out how to get the changes back into Pg.

There is nothing worth a darn in the Access help and working my way through the menus has got me no success.

Quick; please someone hit me with a cluestick! Or if it's too far to reach is there a tutorial on using MS Access and Pg together?

Oh yeah, I looked at pgAccess but the site is down and the registrar indicates it is being deleted. PgAdmin II (since I'm using Pg 7.2) is ...
OK, but too slow for editing by the folks I work with.

TIA,
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match