I have a payroll system project with VB 6.0 and I want to connect it to Database (Access) that located in my office via Public IP.
So, anyone can give me a code to connect that system to Database via Public IP ?
To connect to a remote Access database you must do it over an UNC path, ie
I don't think there's an easy way of connecting to access over IP as it's not a client-server solution where a server application can listen to a IP port.
Remote connections to Access are done on a "file-level".
Maybe create some kind of web-service on the server instead so your app connects to the web-service which connects to the Access database.