?
Solved

Transferring data between computers using Access Database or Socket?

Posted on 2012-03-22
6
Medium Priority
?
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 total points
ID: 37754689
0
Technology Partners: 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!

 

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 51

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
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.
Suggested Courses

752 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