[AccessD] Raise Event Across Network

DWUTKA at marlow.com DWUTKA at marlow.com
Tue Nov 29 14:46:15 CST 2005


My UDP solution won't use any timers.  VERY easy to code and implement, and
lightning fast.  

Drew

	-----Original Message-----
	From:	Robert Gracie [SMTP:robert at servicexp.com]
	Sent:	Tuesday, November 29, 2005 2:53 PM
	To:	Access Developers discussion and problem solving
	Subject:	Re: [AccessD] Raise Event Across Network

	 
	Josh,
	 This is a pretty complex app, so I can't run any timers, or else I
have
	problems, big problems .. :-) 

	Robert Gracie
	www.bgsysnow.com

	-----Original Message-----
	From: accessd-bounces at databaseadvisors.com
	[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Josh
	McFarlane
	Sent: Tuesday, November 29, 2005 3:00 PM
	To: Access Developers discussion and problem solving
	Subject: Re: [AccessD] Raise Event Across Network

	On 11/29/05, Robert Gracie <robert at servicexp.com> wrote:
	> Hello,
	>  Is it possible to Raise an Event Across A Network In Access of
the 
	> same app?
	>
	> Sort of like a communication channel between the same app on
	network...

	Well, a hack I could think of would be to have a table with
messages,
	and have code running on a timer in the background that polls the
linked
	table. When a record exists, it makes a note of it and does the
	according action based on the data in the table, and makes an
internal
	note that the action has been dealt with, maybe with a local table
(if
	you need a permenant log of communication) or just internally in
memory
	(if the message in the table can be wiped after it expires, for
example,
	a shutdown notice).

	Of course, this isn't real time, and the shorter the delay on
	realizations the more of a performance hit you take from polling the
	table across the network. Not sure if VBA has any socket code
	capabilities.

	--
	Josh McFarlane

	"Peace cannot be kept by force. It can only be achieved by
	understanding."
	-Albert Einstein
	--
	AccessD mailing list
	AccessD at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/accessd
	Website: http://www.databaseadvisors.com


	-- 
	AccessD mailing list
	AccessD at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/accessd
	Website: http://www.databaseadvisors.com



More information about the AccessD mailing list