Our company purchased some preventative maintenance software from a vendor. One of the tables that the software uses is a machine table that contains machine descriptions, serial numbers, maintenance intervals, etc. We have recently converted our own internal software to SQL Server and our own software has a machine table that contains much of the same information that's used for other purposes besides preventative maintenance. Ideally, we'd like to maintain only one table so that two tables don't get out of sync. Provided we set up our own internal table in SQL server identically to the Access table used by the software, is it possible to force the software that uses the Access table to use the SQL server table instead? What's involved in doing something like this?
Thanks in advance.
Thanks in advance.