473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

notification of changes between apps on different pc's on the network

I will be developping a planning application for wich it's necessary for
multiple users to view and edit the same data, all changes made by one user,
must be visible to the other user's more or less immediately (on their pc).
So I'm looking for a mechanism with wich I can notify the 'other'
applications on the network of any changes so they can update their 'view'
if necessary.

Although I think I'm capable of solving this problem by re-inventing the
wheel, I'm pretty sure it's already been done, and probably better and more
robust than my first few attempts would be... So can anyone help me out ?
thanks,
Jurjen.

Sep 26 '08 #1
2 1909

Well i can think of 3 easy ways of acomplishing that
1. if you use SQL server as database backend you could setup notification
services the database performs a callback to your app whenever the dataset
you subscibed to has a change

2. You could create a change mechanism yourself ,,, actually i have done
this a few years ago before we had notification services the following way
let a trigger in your database create a new guid in a watch table
whenever there are changes made in the main table ( you could even implement
this with a low entry "database" as ACCESS however then you should do this
from code .

now when you app gets its dataset it will also retrieve the guid and compare
this once in a while with a backgound thread to the current database value
if it has changed if it has changed you know there are changes and thus need
to update your working set .

3. You could do a broadcast on the network whenever one of the applications
perfomed a change on the dataset , then all running instances can update
there datasets

Maybe someone else has some more ideas !?

regards
Michel Posseth [MCP]
http://www.vbdotnetcoder.com



"Jurjen de Groot" <Ju*************@xs4all.nlschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...
>I will be developping a planning application for wich it's necessary for
multiple users to view and edit the same data, all changes made by one
user, must be visible to the other user's more or less immediately (on
their pc). So I'm looking for a mechanism with wich I can notify the
'other' applications on the network of any changes so they can update their
'view' if necessary.

Although I think I'm capable of solving this problem by re-inventing the
wheel, I'm pretty sure it's already been done, and probably better and
more robust than my first few attempts would be... So can anyone help me
out ?
thanks,
Jurjen.

Oct 5 '08 #2
Michel,

thanks for your reply, in the mean Time I have found several articles
concerning PublishSubscribe scenario's and am looking into a solution
created by juval lowy from idesign wich seem to do the trick,

thanks.
"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:eC*************@TK2MSFTNGP03.phx.gbl...
>
Well i can think of 3 easy ways of acomplishing that
1. if you use SQL server as database backend you could setup notification
services the database performs a callback to your app whenever the dataset
you subscibed to has a change

2. You could create a change mechanism yourself ,,, actually i have done
this a few years ago before we had notification services the following way
let a trigger in your database create a new guid in a watch table
whenever there are changes made in the main table ( you could even
implement this with a low entry "database" as ACCESS however then you
should do this from code .

now when you app gets its dataset it will also retrieve the guid and
compare this once in a while with a backgound thread to the current
database value if it has changed if it has changed you know there are
changes and thus need to update your working set .

3. You could do a broadcast on the network whenever one of the
applications perfomed a change on the dataset , then all running instances
can update there datasets

Maybe someone else has some more ideas !?

regards
Michel Posseth [MCP]
http://www.vbdotnetcoder.com



"Jurjen de Groot" <Ju*************@xs4all.nlschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...
>>I will be developping a planning application for wich it's necessary for
multiple users to view and edit the same data, all changes made by one
user, must be visible to the other user's more or less immediately (on
their pc). So I'm looking for a mechanism with wich I can notify the
'other' applications on the network of any changes so they can update
their 'view' if necessary.

Although I think I'm capable of solving this problem by re-inventing the
wheel, I'm pretty sure it's already been done, and probably better and
more robust than my first few attempts would be... So can anyone help me
out ?
thanks,
Jurjen.

Oct 9 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: jason | last post by:
I could sure use some conceptualization and query help with a Page Watch System I am building in Access 2000 and Asp. I need to cycle through databae and generate a compiliation query email that...
9
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
3
by: geskerrett | last post by:
We have been asked to develop and application for a client that is a 'notification" system. We would like to use python, but are struggling to find the right starting point. Any suggestions, tips...
2
by: teddysnips | last post by:
We've been supporting a number of Access applications for a particular client for some years. Some of them were written by third parties, some by us (even one or two by me, though not this...
9
by: TC | last post by:
Like a lot of database developers, I often choose Jet for the back- end. I'm starting to worry about what will happen when Jet is deprecated. Ostensibly, Jet users like me must switch to SQL Server...
2
by: cjard | last post by:
Suppose: A TextBox is bound to a BindingSource, which is bound to a DataTable A BindingNavigator is used to alter the current row being looked at by the BindingSource (i.e. Nav's NEXT button is...
10
by: bramnizzle | last post by:
I don't know if this is the right thread or not, but... In my endless pursuit to hold on to my dinosaur laptop (Dell 1100 Inspiron - circa 2004)...I want to keep as much space free for my...
13
by: John | last post by:
Hi How can I send simple messages/command like "GotoClientRecord=1024" or "GotoSupplierRecord=234" from a vb.net app to a) a vb.net winform app and b) an MS Access app, all three running on the...
1
ashitpro
by: ashitpro | last post by:
Hi there, I am working on a distributed service detection project, written in C/C++ Platform is Linux. Each system under network has mysql database for general storage. If first node queries to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.