Transferring data between computers using Access Database or Socket?
Posted on 2012-03-22
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.