I'm using MS Access with two computers connected to the same network

[nector]

I have two computers using the same network in the same building storing the information on MYSQL (Cloud), now as long as I'm in the same building computer B can access the resources stored on computer A which is the JAVA file by using port number 8080 because the public IP address on both computers are the same.

Now here is the problem I move the same computers from one town to another town with the same router when I switch on both computers and connect to the same router then the router assign two different public IP address as result now computer B can no longer use the resources on A.

What do I to ensure that both computers are using the same public IP address and continue sharing the the same resources?

 

[Minty]

The public IP will be shared by anything going through the same router, unless there is a VPN involved r some clever DNS Setting being used?
However sharing on the same internal network doesn't have anything to do with the Outward facing public IP address ?

 

[The_Doc_Man]

Most of the time, you would most likely be dealing with DHCP - dynamically assigned internal addresses - at the level where two computers connect to the same internal network. That should happen at your "home" network because these days, in an effort to make net configuration easier for the home user, routers default to DHCP Enabled. Then you get address translation via port/address NAT tables.

If you get different addresses then it has to be because one of them is not configured like the other one and so doesn't get assigned an address via DHCP. I.e. one of them instead asserts an address - but the other one doesn't, and so "rides" a different address assignment. Something like that may be going on.

On each machine while on your "home" network, get to the CMD prompt (Windows "Start" >> Windows Tools >> CMD) and make up a file name. Determine the name of the other machine. Then type TRACERT other-machine-name > filename1.TXT - which will capture the output of the command and will probably go into your My Documents area unless you specify a path as part of the destination filename. (Hint: Typically, the CMD prompt itself will tell you where it is going to put any files.) You might have to wait for a while for the command to finish, but really should not. This is the TRACEROUTE program, which tells you the network hops required to get from point A to point B. When you have the file, EXIT from the CMD prompt.

Do that once for each machine and keep that captured file around. (It should be relatively small because it is a text file, no graphics involved.) Now when you are at a different location, repeat the experiment but use filename2.TXT and keep that as well. Compare the filename1 and filename2 files. You will want to see what things are different with respect to the routes that the two machines use for each other. From your description, there should be radical differences between filename1.txt and filename2.txt on at least one of the machines if not both. Note, however, that comparing filename1.txt on machine A might not look the same as filename1.txt on machine B.