-
Access at remote
I'm trying to simulate accessing an Access db at a remote server. (using the local machine acting as the remote server)
Dim oConn As ADODB.Connection
Dim oRS As ADODB.Recordset
Dim sConnString As String
sConnString = "Provider=MS Remote;Remote Server=http://127.0.0.1;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\db\Test.mdb;"
oConn.Open sConnString
Set oRS = oConn.Execute("SELECT * FROM TAB_CATALOG", , adCmdText)
Connection is successfully made, but the sql execution part returns an error :
RDS Server Error: The server has denied access to the default RDS Handler used to access this page. See the Server Administrator for more info about security settings.
Help.....
Thanks in Advance,
Ben