Solved

Transferring data between computers using Access Database or Socket?

Posted on 2012-03-22
6
263 Views
Last Modified: 2014-11-12
I need to transfer data between 20 computers on a LAN.  The data consists of about 500 characters and each computer "sends" the data about once every minute to various other computers on the LAN.  I'm thinking about doing it using an Access database in this way:

* Each user checks a table in a central database frequently.
* If one computer wants to send data to another, he puts data in the other user's table.
* When a user finds data in his table he uses it.

Will using this method with 20 computers all on a local LAN be ok?  Or would that cause any lag?

I realize I could use socket programming for this, but, for reasons not worth going into, I don't want to change any firewall settings on any of the computers.
0
Comment
Question by:pdering
  • 3
  • 2
6 Comments
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37754407
no need to use database here, its simple broadcasting a message on lan.
Here is a link to help you:-
http://www.codeproject.com/Articles/326868/Send-receive-messages-in-LAN-with-broadcasting
0
 

Author Comment

by:pdering
ID: 37754679
If I use  UDP broadcasting then I could need to open ports on the computers firewalls correct?
0
 
LVL 20

Accepted Solution

by:
BuggyCoder earned 500 total points
ID: 37754689
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:pdering
ID: 37755090
Can WCF queued messaging be installed completely programatically?
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37755802
yes just follow the examples and host your service in your application....
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 37756361
Or why not Amazon Simple Queue Service

Amazon Simple Queue Service (Amazon SQS):
http://aws.amazon.com/sqs/

AWS SDK for .NET here:
http://aws.amazon.com/sdkfornet/

It will probably be free to use for you and will, of course, work from any location with Internet access.

/gustav
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
AWS EC2 Linux 1 35
Launch Process with NOT as Administrator 15 66
Image(7) 1 37
Events in static methods 3 25
Hello to you all, I hear of many people congratulate AWS (Amazon Web Services) on how easy it is to spin up and create new EC2 (Elastic Compute Cloud) instances, but then fail and struggle to connect to them using simple tools such as SSH (Secure…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now