Hi - A client is running an access database on their in-house server. It is not connected to the internet.
We have an MSSQL database connected to a web-server.
We would like to have them update a field in their own database and then communicate with our own server so that they can update the same field on our own database.
One solution I had thought would work is to place a url on their user interface that, when clicked, then opens an internet browser window, talks to our database and then updates a field on our own database.
This url would have to be dynamic, that is, the url could look like this: