Please, help me to solve this problem

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

I am developping multi-user windows application. i use Access database.
user edit, add and delete data from database.

Request:
when an item is deleted ,added or modified by an user, all others user in
the network which has application running should automatically see the
change. in case of remove action, the item should disappear from the
listview.


Problem:
Because i am using dataset, user should manualy refresh( i create a refresh
button,which refill the dataset) in order to see changes of anothers user.
if user doesn't refresh, he still continues to edit an item which doesn't no
more exist in the database because it's removed by another user.

Users doesn't like this method and they wants from me that everything works
like outlook in exchange mode( any action(add, remove message) in public
folders by a user is automatically shown in all others outlook clients
connected to ms exchange server)


How to solve this problem?:
I need a way to know (in my application)if a row is added, removed or
updated in the database by another user so that others users can update
their listview.

Someone suggest me to use Ms SQL server. does sql server send a message to
users if a row of a table is modified or deleted???


Please help me.


Thanks you.

Elysee
 
You can send a refresh event to client interface when such operation occured
on database, so the refresh is automaticaly triggered by the user that
modify the data
 
How to send a refresh event from another application to others applications

Application are interconnected only by use of the same database in the
network.
the number of copies of application and IPs of Pcs are unknown in
advances...
 
-I know that you are going to talk about remoting that is why i wrote i
don't know IP of computers where my application is going to be installed.
there are using DHCP and IPS changed everydays and whithout known IPs i
can't use remoting.

-in reality, My application is not EXE application but an Addin for outlook
even if some of features are not related to outlook. so i don't know if
remoting work with dll...
 
If you know your server address then you can connect with the client dll or
whatever it is to server and the server can signal any changes back to
client...
 
Thanks you. i like this idea.

What happens if two remoting servers are listenning in the same port?
i am asking because if another another unknow application of unknown company
is listening in the same port as my server,how can i resolve the colision?
 
Just pick up another port.
You can make a list in the client too
The client that cant connnect on first one can try another one in the list,
but there are small chances that another aplication listen on the same port.
Choose one around 10000.
 
Back
Top