What you need is one of the following applications:
TeamViewer, Gotomypc, or Logmein
They are designed to connect to your PC remotely without a fixed IP. Personally I like TeamViewer because the free version has file transfer capabilities however all of them have free apps.
Hey Guys. Thanks for the posting however you have missed the point of my original post. I do not want to connect to another computer. I want an MS Access database sitting on a PC to have its database (backend) located on an Internet Server. If I was using MySql instead of Access, I would have no problem because MySql provides an ODBC connector which is dead easy to use. I cannot find a similar ODBC Connector for MS Access other than for local connections via ADO. Surely somebody out there must be connecting to an MS Access database via the Internet from an MS Access program sitting on a PC. Please?