How do I use Access on a web server?

M

Mark

I want to be able to store my access database on a web server and access it
from there. But when I put it on a web server and try to open the file it
gives me error message saying that it is not of html format. Is there a way
to remedy this situation?
 
A

Arvin Meyer

You need to set up a DSN or a Connection String and tell IIS about it:

Sub OpenConnect()
Dim oConn

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.ConnectionString = "DSN=MyDSN"

' oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Data.mdb;Persist Security Info=False"

oConn.Open

End Sub
 
Top