Howdy all,
Just a quick one here. My company has an automated scrap system that is currently storing the results in MSSQL 2005 located on someone's C Drive. I have created a database (FE/BE) to store production data and I would like to tie in the automated scrap system. This computer is on all the time (and is connected to the network). I was wondering what the best method would be to get the data from MSSQL located on this dudes pc to the back end of my database. Obviously I'd like to make it transparent. I started by creating a form with an On Timer event - Pulling the data based on time then sending it to my back end db. I'm sure there are a bunch of ways to do it but I'd like to hear from the experts. Thanks A lot!
Just a quick one here. My company has an automated scrap system that is currently storing the results in MSSQL 2005 located on someone's C Drive. I have created a database (FE/BE) to store production data and I would like to tie in the automated scrap system. This computer is on all the time (and is connected to the network). I was wondering what the best method would be to get the data from MSSQL located on this dudes pc to the back end of my database. Obviously I'd like to make it transparent. I started by creating a form with an On Timer event - Pulling the data based on time then sending it to my back end db. I'm sure there are a bunch of ways to do it but I'd like to hear from the experts. Thanks A lot!
