Solved Forwarding the port number to access Tomcat server in MS Access

[nector]

I'm using an MS Access to process invoices by trying to connect to the Tomcat Server which is located in another room, I'm able to access the MS Access database by using the local area network without any problem. Now to access the Tomcat server file(communication file) on that computer by workstations we are using a router by running cables to the server for the provision of internet services.

In order to allow the workstation stations communicate with the server I have opened the port 8080 via window fire wall and the IP address I have made it static, but when I try to communicate from the work stations see the message I'm getting I'm failing to interpret it

Where do I go wrong??

 

[MarkK]

when I try to communicate from the work stations

Maybe you can describe in greater detail what this means.

 

[The_Doc_Man]

The first thing that comes to mind is that it is complaining about the AfterUpdate event code (or Macro) and therefore you should look into what it was trying to do in that event code. It would help for US to know that, too, since you are trying to interpret what it means.

 

[nector]

Okay

When I try to send the invoice details to the server so that the server now takes up the communication with the virtual machine about the tax and sales details that is when I get that error, it looks like the communication is blocked somewhere.

 

[nector]

Well it is sorted out

What it wanted was to reference the IP address for the server, that where I was making a mistake. This code below was just referencing the local workstation IP address:

stUrl = "http://kocalhost:8080/nectordbs/items/save"

So the correct way is to do it like below:

stUrl = "http://" & Forms!frmLogin!txtIpAddress.Value & ":8080/nectordbs/items/save"

Many thanks for contributors especially The Doc Man he made be to think critically