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
7  1642 
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
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
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
-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
>
>
>
>
>
>
>
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
> >
> >
> >
> >
> >
> >
> >
>
>
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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
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
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: stu_gots |
last post by:
I have been losing sleep over this puzzle, and I'm convinced my train
of thought is heading in the wrong direction. It is difficult to
explain my circumstances, so I will present an identical...
|
by: Jason |
last post by:
Hi,
I was wondering if any could point me to an example or give me ideas on how
to dynamically create a form based on a database table? So, I would have a
table designed to tell my application...
|
by: CoreyWhite |
last post by:
It is possible to use martingale probability theory to beat some games
of chance. In a fair game of coin toss, where the odds reach an
equilibrium of 50/50 chain reactions do occur. This can be...
|
by: settyv |
last post by:
Hi,
Below is the Javascript function that am trying to call from asp:Button
control.
<script language="javascript">
function ValidateDate(fromDate,toDate)
{
var fromDate=new Date();
|
by: shapper |
last post by:
Hello,
For the past hours I have been trying to solve a problem which is
driving me crazy.
I have to different codes where the problem to solve is the same:
CODE 1 (Transforms a XML...
|
by: rocksoft |
last post by:
Hi,
I am working in asp.net with C# web application, i have used one textbox and image button for search
funtion, i have created one user control for this, but after i have entered...
|
by: rashmidutt |
last post by:
hello sir
i am making project on vb.net language..and project is on hospital management..its major project..and too many fields are present in its data base..i was connecting data base in forms but...
|
by: itsvineeth209 |
last post by:
My task is to create login control without using login control in tools. I shouldnt use sqldatasource or any other. I should use only data sets, data adapters and data readers etc.
U had created...
|
by: shapper |
last post by:
Hello,
I am creating a form that includes a few JQuery scripts and TinyMCE
Editor:
http://www.27lamps.com/Beta/Form/Form.html
I am having a few problems with my CSS:
1. Restyling the Select
|
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...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| | |
