SQL Connection Idea ?

[Grudge]

I'm working on a new project for a factory and what we have done is basically setup a SQL server which keeps data from all the processes in the plant. We have workstations at the different processes which get data from the different machinery. These workstations feed the data into the SQL server. The problem we're having is what kind of solution can I implement that when the network connection goes down, how can I make sure that it will keep all the data on that workstation until the connection is restored again, and then it must send the data to the SQL server. The perfect solution would be to mirror the table(s) which the program needs on the workstation, and when the link is restored it updates the main SQL database ?

Any ideas on how I would do that ?

 

[fluteplr]

I would look at using ADO disconnected record sets. I would also look at why the network is going down. In this day and age there is little excuse for that to be a regular occurance.

 

[Grudge]

It's not that there is network problems but, if there should one day for some or other reason by a connection problem then the plant cant stand still...