远程连接MS Access数据库
环境：

XPSP2 + IIS + .Net 3.5 + VS2008



代码：

Dim connectionString As String = _
"Provider=MS Remote;" & _
"Remote Server=http://127.0.0.1;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\tmp\1.mdb;Persist Security Info=False"

Me.dataAdapter = New OleDbDataAdapter("select * from t1", connectionString)

Me.dataAdapter.Fill(ds, "my_table") <- Exception



错误信息：

System.Data.OleDb.OleDbException was unhandled
ErrorCode=-2146819841
Message="Internet 服务器错误。"
Source="Microsoft ADO/RDS"



[解决办法]
access 是通过文件访问来实现的，你这种方法不行。只能在远程共享文件目录来实现。