SQL Server to Microsoft Access data transfer
Posted on 2011-03-23
We just added an old (NT 4.0 Workstation) computer to our business network as it powers a large Chop saw in our factory. The saw operates via a software program that runs on the PC that access a local MS Access database on the C drive.
We want to populate the access database from a 2008 SQL Server with data on a daily basis (small amount of data - say 200 records. These records are currently inputted by hand via the software program on the PC). What is the best method? Can the SQLServer talk directly to the access database on the Nt Workstation? i have confirmed that there is no security on the access database