Dennis,

IMO you need to specify the "Remote provider" property in your connection string.

>I need to make a connection to create a remote view for an Access database located on the web.
>
>This connection string works in this scenario:
>
>oConnection = CreateObject("adodb.connection")
>
>oConnection.open("remote server=http://hosenose.com;Provider=MS Remote.1;handler=MSDFMAP.Handler,sfdb.ini;data source=pda_hosenose_sf")
>
>rs = CreateObject("adodb.recordset")
>
>rs.Open("Select * From sfcpayments",oConnection)
>...
>
>When I enter this connection string in the Connection Designer and click Verify, the Select Data Source window opens. Likewise, if I create the connection programmatically, the Select Data Source window opens when I attempt to use the connection.
>
>I included a dummy DRIVER=XYXXY; clause in the connection string, and it no longer prompts for a Data Source--it just fails to connect, as one would expect. Must I specify a proper driver, and if so, what?
>
>Any help will be greatly appreciated.