Solved

Transferring data between computers using Access Database or Socket?

Posted on 2012-03-22
6
268 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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 50

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Review of Cloudberry Explorer Pro - Linked with Amazon Web Services (AWS) S3 Being a Cloud technology fan and in particular services that are provided by AWS, I was interested to find a growing number of vendors writing software and applications …
Monitoring systems evolution, cloud technology benefits and cloud cost calculators business utility.
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.

756 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