Home Forums SQL Server 2014 Development - SQL Server 2014 Access to SQL Server - How to Auto Update Multiple Tables Daily RE: Access to SQL Server - How to Auto Update Multiple Tables Daily

  • April 23, 2015 at 12:20 am

    #1792928

    Orlando Colamatteo (4/22/2015)

    +1 to the idea of removing Access from the equation if possible and having the data provider write to SQL Server. If that is not possible then look into converting the tables in Access to Linked Tables that reference tables in a SQL Server database.

    http://www.mssqltips.com/sqlservertip/1480/configure-microsoft-access-linked-tables-with-a-sql-server-database[/url]

    Thanks for the idea of linked tables Orlando Colamatteo. I will try it to see if that can solve my current problem problem.

    Regards