I have an Access 2010 client app that pushes data to my SharePoint site in Office 365 using SharePoint tables linked in the application. I do not edit the data after it's uploaded to SharePoint.
Access automatically keeps the two sides (Access and SharePoint in sync) which is a nice feature normally. However, in my case, it's not needed, since the data doesn't change.
Is it possible to push data to sharepoint without using the synchronized sharepoint tables in Access? The reason I ask is that as my SharePoint tables get larger, it's going to be harder to manage having that much data in an Access file.
I would prefer a situation similar to an ODBC link to SQL Server, where the data isn't stored in the link, but it's only brought into Access when it's needed. That would work much better for my situation.
Is it possible to just link to the SharePoint data instead of having a copy of all the SharePoint data tables stored within my Access accdb file?


Thanks!