I have a SQL Server table in my ArcGIS Online web app.
It is related to 2 other feature classes also in my map.
The source table is a non spatial table being related on a common field.
Not sure what more to add about the connection.
I've connected to the SQL Server table in ArcMap and related it to my feature classes then published it to ArcGIS Online
The SQL Server table is updated frequently, however these updates to the table are not reflected in my web app.
The updates are new values in existing columns.
I can see them in the .mxd locally, but they do not appear in the SQL Server table being used in my web app. I have not registered the connection on the ArcGIS Server host so the data is copied each time I publish the map service.
What can I do so that my SQL Server table updates with any new values entered into it from Microsoft Access?