Thanks for your reply Alexander.

The DSN pda_storefront_sf uses an Access database. Do you know what the remote provider would be? I tried putting in a dummy parameter for REMOTE PROVIDER= and VFP still brings up the connection designer.

Thanks,

Dennis

>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.