Transferring data between computers using Access Database or Socket?

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.
pderingAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BuggyCoderCommented:
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
pderingAuthor Commented:
If I use  UDP broadcasting then I could need to open ports on the computers firewalls correct?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Defend Against the Q2 Top Security Threats

Were you aware that overall malware worldwide was down a surprising 42% from Q1'18? Every quarter, the WatchGuard Threat Lab releases an Internet Security Report that analyzes the top threat trends impacting companies worldwide. Learn more by viewing our on-demand webinar today!

pderingAuthor Commented:
Can WCF queued messaging be installed completely programatically?
0
BuggyCoderCommented:
yes just follow the examples and host your service in your application....
0
Gustav BrockCIOCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.