Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id DC043476876
	for <pgsql-interfaces@postgresql.org>;
	Thu,  4 Jul 2002 20:52:51 -0400 (EDT)
Mailbox-Line: From apcl79@dsl.pipex.com  Thu Jul  4 20:52:51 2002
Received: from colossus.systems.pipex.net (colossus.systems.pipex.net
	[62.190.223.73])
	by postgresql.org (Postfix) with ESMTP id 333274767D3
	for <pgsql-interfaces@postgresql.org>;
	Thu,  4 Jul 2002 20:50:31 -0400 (EDT)
Received: from server (81-86-170-203.dsl.pipex.com [81.86.170.203])
	by colossus.systems.pipex.net (Postfix) with SMTP id 029B21600025F
	for <pgsql-interfaces@postgresql.org>;
	Fri,  5 Jul 2002 01:50:34 +0100 (BST)
Message-ID: <002c01c223be$1b033a70$5858fea9@server>
From: "Stavros Karposilos" <apcl79@dsl.pipex.com>
To: <pgsql-interfaces@postgresql.org>
Subject: MS Access 2K Inform User on Record changes
Date: Fri, 5 Jul 2002 01:51:30 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0027_01C223C6.7BF5D380"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Spam-Status: No,
 hits=0.8 required=5.0 tests=FROM_ENDS_IN_NUMS,SUPERLONG_LINE
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/14
X-Sequence-Number: 2823

This is a multi-part message in MIME format.

------=_NextPart_000_0027_01C223C6.7BF5D380
Content-Type: text/plain;
	charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

  I have been very troubled the last days trying various ways to notify the=
 frontend MS Access 2K Client when a table on the Backend has changed.
  All my attempts have resulted to a failure.
  I realise now that the Notify/Listen solution is not going to work. I als=
o tried to create an external C routine, callable by Trigger, which was usi=
ng a TCP/IP socket to connect to each client but I didn't manage to convinc=
e it to work without crashing.
  I would greatly appreciate a working example, or a point to a solution of=
 whatever form.

  I am using PostgreSQL 7.2 running on RedHat Linux 7 networked with 8 clie=
nts running Win9x and MSAccess2K on a plain 10MBps Ethernet Network.

  Thanks in advance, Stavros

------=_NextPart_000_0027_01C223C6.7BF5D380
Content-Type: text/html;
	charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-7" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&nbsp; I have been very troubled the last =
days=20
trying various ways to notify the frontend MS Access 2K Client when a table=
 on=20
the Backend has changed.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; All my attempts have resulted to a=
=20
failure.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; I realise now that the Notify/Liste=
n=20
solution is not going to work. I also tried to create&nbsp;an external C=20
routine, callable by Trigger, which was using a TCP/IP socket to connect to=
 each=20
client but I didn't manage to convince it to work without crashing.</FONT><=
/DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; I would greatly appreciate =
a working=20
example, or a point to a solution of whatever form.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; I am using PostgreSQL 7.2 r=
unning on=20
RedHat Linux 7 networked with 8 clients running Win9x and MSAccess2K on a p=
lain=20
10MBps Ethernet Network.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; Thanks in advance,=20
Stavros</FONT></DIV></BODY></HTML>

------=_NextPart_000_0027_01C223C6.7BF5D380--