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"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
