Skip site navigation (1) Skip section navigation (2)

A *pass-through-query* from postgreSQL to MsAccess

From: DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: A *pass-through-query* from postgreSQL to MsAccess
Date: 2001-06-06 17:52:03
Message-ID: 00ba01c0eeb1$651a0500$01011eac@irina (view raw, whole thread or download thread mbox)
Lists: 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

E-Mail: i(dot)hasenoehrl(at)aon(dot)at


pgsql-odbc by date

Next:From: Cedar CoxDate: 2001-06-07 06:24:14
Subject: Re: A *pass-through-query* from postgreSQL to MsAccess
Previous:From: Dave PageDate: 2001-06-06 07:08:32
Subject: RE: which odbc driver from ftp

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group