Connect VB 6.0 Project to Database (Access) via Public IP

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 ?



My Problem

1 answer

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.