A *pass-through-query* from postgreSQL to MsAccess - Mailing list pgsql-odbc

From DI Hasenöhrl
Subject A *pass-through-query* from postgreSQL to MsAccess
Date
Msg-id 00ba01c0eeb1$651a0500$01011eac@irina
Whole thread Raw
Responses Re: A *pass-through-query* from postgreSQL to MsAccess
List pgsql-odbc
Hello all,
 
I use postgresql as backend and MsAccess97 as frontend via ODBC.
I know, how to use VBA and pass through queries to update or insert rows in postgresql-tables.
But I don't know, how to do this the other way round, from postgresql to MsAccess.
I want to develop a trigger, which updates or inserts rows in some local tables in MsAccess on the client side.
 
How can I realize a *pass through query* in postgresql ( with plpgsql ?) to be executed in MsAccess?
 
Is there a possibility, to send updates or inserts from postgresql-tables to local MsAccess-tables (without linked tables)
 
I have the following situation:
1 postgresql database and some clients on different locations, connected via internet
I want to hold some information realy local (no linked table) to the clients and to the host, because the connection is not very fast
when client_1 changes a special table in the postgresql DB, this should be transmitted to a local MsAccess-table to client_2
Can I solve this problem with plpgsql????????????
 
Please, can anyone help me to solve this problem.
 
Thanks in advance
Irina
 

pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: RE: which odbc driver from ftp
Next
From: Cedar Cox
Date:
Subject: Re: A *pass-through-query* from postgreSQL to MsAccess