Access at remote

[benhwa]

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