connecting to a remote access db

[chris1990]

Is it possible to connect to an access database on a web server. I found this in the faq http://www.vbforums.com/showthread.php?p=2223896, but i think it means a server on a local network.

thanks in advance
chris1990

[Paul M]

That link does exactly what you want Just make sure the server has IIS i suppose and have a look over the MSDN link included in RhinoBull's post

[lerroux]

rhinobull posted something like: #
strConString = "Provider=MS Remote;" & _
#
"Remote Server=http://192.168.1.1;" & _
#
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
#
"Data Source=MyRemoteDB;Persist Security Info=False"

do that... change the ipaddress to your server's public ip address, not the private address if it's on the internet...