go in the other direction... Convert your table in MS Access to use a
pass-through query to the postgreSQL table. Connect yoour MS Access pass
through table to postgreSQL using OBBC.
Even better: Drop MS Access completely and just use postgreSQL. Access is a
totally inferior technology.
""carter ck"" <carterck32@hotmail.com> wrote in message
news:BAY101-F28C98428FE76C9CB51D1D3D5A20@phx.gbl...
> Hi all,
>
> Is there any way that I can synchronize a table in Postgres on Linux with
> another table in Ms Access?
>
> The requirement of the assignment is as following:
>
> In postgres, there is a table called message_received. Whenever we insert,
> update or edit this table, the table in Ms Access should also be updated.
>
> Advices and suggestions are all welcomed and appreciated.
>
> Thanks
>
> _________________________________________________________________
> Get an advanced look at the new version of Windows Live Messenger.
> http://get.live.com/messenger/overview
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>