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
Printable View
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
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 ;)
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...