By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,883 Members | 955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,883 IT Pros & Developers. It's quick & easy.

Please, help me to solve this problem

P: n/a
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



Nov 20 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ur*************@TK2MSFTNGP10.phx.gbl...
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


Nov 20 '05 #2

P: n/a
Mat
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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:uk**************@TK2MSFTNGP11.phx.gbl...
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

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ur*************@TK2MSFTNGP10.phx.gbl...
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



Nov 20 '05 #3

P: n/a
Well, You can use Remote

http://samples.gotdotnet.com/quickst...nfeatures.aspx

or some socket and TCP based client-server system...

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:uk**************@TK2MSFTNGP11.phx.gbl...
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

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ur*************@TK2MSFTNGP10.phx.gbl...
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




Nov 20 '05 #4

P: n/a
Mat
-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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:O0**************@tk2msftngp13.phx.gbl...
Well, You can use Remote

http://samples.gotdotnet.com/quickst...nfeatures.aspx
or some socket and TCP based client-server system...

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:uk**************@TK2MSFTNGP11.phx.gbl...
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

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ur*************@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>
>
>
>
>



Nov 20 '05 #5

P: n/a
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...
--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ej**************@tk2msftngp13.phx.gbl...
-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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:O0**************@tk2msftngp13.phx.gbl...
Well, You can use Remote

http://samples.gotdotnet.com/quickst...nfeatures.aspx

or some socket and TCP based client-server system...

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:uk**************@TK2MSFTNGP11.phx.gbl...
> 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
>
> --
> Ceers,
> Crirus
>
> ------------------------------
> If work were a good thing, the boss would take it all from you
>
> ------------------------------
>
> "Mat" <re**********@fuckSpam.COM> wrote in message
> news:ur*************@TK2MSFTNGP10.phx.gbl...
> > 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
> >
> >
> >
> >
> >
> >
> >
>
>



Nov 20 '05 #6

P: n/a
Mat
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?

"Crirus" <Cr****@datagroup.ro> wrote in message
news:uy**************@TK2MSFTNGP10.phx.gbl...
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...
--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ej**************@tk2msftngp13.phx.gbl...
-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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:O0**************@tk2msftngp13.phx.gbl...
Well, You can use Remote

http://samples.gotdotnet.com/quickst...nfeatures.aspx

or some socket and TCP based client-server system...

--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
> 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...
>
>
> "Crirus" <Cr****@datagroup.ro> wrote in message
> news:uk**************@TK2MSFTNGP11.phx.gbl...
> > 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
> >
> > --
> > Ceers,
> > Crirus
> >
> > ------------------------------
> > If work were a good thing, the boss would take it all from you
> >
> > ------------------------------
> >
> > "Mat" <re**********@fuckSpam.COM> wrote in message
> > news:ur*************@TK2MSFTNGP10.phx.gbl...
> > > 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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>



Nov 20 '05 #7

P: n/a
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.
--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:eC**************@TK2MSFTNGP12.phx.gbl...
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?

"Crirus" <Cr****@datagroup.ro> wrote in message
news:uy**************@TK2MSFTNGP10.phx.gbl...
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...
--
Ceers,
Crirus

------------------------------
If work were a good thing, the boss would take it all from you

------------------------------

"Mat" <re**********@fuckSpam.COM> wrote in message
news:ej**************@tk2msftngp13.phx.gbl...
-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...
"Crirus" <Cr****@datagroup.ro> wrote in message
news:O0**************@tk2msftngp13.phx.gbl...
> Well, You can use Remote
>
>

http://samples.gotdotnet.com/quickst...nfeatures.aspx
>
> or some socket and TCP based client-server system...
>
> --
> Ceers,
> Crirus
>
> ------------------------------
> If work were a good thing, the boss would take it all from you
>
> ------------------------------
>
> "Mat" <re**********@fuckSpam.COM> wrote in message
> news:%2****************@tk2msftngp13.phx.gbl...
> > 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...
> >
> >
> > "Crirus" <Cr****@datagroup.ro> wrote in message
> > news:uk**************@TK2MSFTNGP11.phx.gbl...
> > > 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
> > >
> > > --
> > > Ceers,
> > > Crirus
> > >
> > > ------------------------------
> > > If work were a good thing, the boss would take it all from you
> > >
> > > ------------------------------
> > >
> > > "Mat" <re**********@fuckSpam.COM> wrote in message
> > > news:ur*************@TK2MSFTNGP10.phx.gbl...
> > > > 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
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Nov 20 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.