Linked sharepoint tables don't sync? (1 Viewer)

[supmktg]

I have 2 separate Access 2013 Web Apps on a Sharepoint 365 server.

Web App 1 was created by uploading related tables to the Sharepoint Azure SQL. I am hoping to use that app strictly for housing the tables which are currently linked to a desktop application which is working very well.

I'm currently working on Web App 2 which will allow remote data entry into the tables of Web App 1. I tried to linked the Web App 1 tables to Web App 2, through an ODBC connection. The tables and data are all there. If I update data via the Desktop application or within Web App 1, it does not reflect the changes in the tables of Web App 2.

It seems as though these tables where imported rather than linked. Although there is an option to Link Sharepoint lists, these are actually Azure Sql Server tables, and are not listed in the 'list' of Sharepoint lists.

Am I out of luck in creating Web App 2 for my purposes, or is there a way to actually link the tables from Web App 1?

Thanks!

Sup

 

[aubrey1983]

I believe this is possible base from my test. updating the tables through ODBC.
Just make sure the keys are selected properly when linking tables, to allow update.