Solved How to connect MS Access users from public internet via secured MS SQL Cloud Database (1 Viewer)

[nector]

We have 10 salesmen who go in the field to go and sell our products (They all have tablets with Windows 11 and Access 365 as FE), the taxman require them to issue a digital tax invoice right there in the field, but to do that they need to connect to our local server and this can be done via WIFI with same network and static IP Address if they are in the plant. All users in the plant go through WAR deployed on the appache Tomcat server and as long as they are on the same network with a static IP address all is fine. They are able to issue tax invoices

Question

Is there a way to connect to this same appache Tomcat server from another network which can allow fields sales team access the appache Tomcat server and issue a tax invoice right there in the field?

Regards

Chris

 

[The_Doc_Man]

If you have a web page through TOMCAT that would do this without involving Access at all, it should be possible. Web pages use HTTP and HTTPS protocols to get to their data, and that works locally or through the web.

Access using ODBC can also have some success through WAN, though it is still risky if the connection breaks. (Which is common for WiFi.)

Access relying on SMB protocol to interact across a WAN or through WiFi would fail miserably and corrupt the database the first time you have a network drop, and in that environment, you WILL have hiccups. But you have SQL so your ODBC protocols will tend to minimize corruption.

There is also the odd chance that you could use RDP or CITRIX to create a remote desktop on your server for which Access would be local to the server and thus not run into the numerous ills of WiFi and HTTP connectivity - neither of which works well with Access.