I have a split database that is stored on a network drive. Most of the tables are updated via the front end with use of forms. I would like to have one table that is updated solely through a SharePoint List. All of my queries and reports are currently built with an existing table. I have looked into linking to SP, but it creates a new copy of the table. Can I then link the 2 tables? So that my queries/reports all work?
Project Table = exists today
When trying to link, creates a new table Project Table 1.
Project Table = exists today
When trying to link, creates a new table Project Table 1.
Access Table Linked to Sharepoint List
