Dear Sir,



I want to connect to a remote MS Access Database which I have uploaded to 

the site where i have got my site placed. Along with my asp pages , i have 

uploaded MS Access Database file also. Now I want to update my Access 

Database. I tried through code as below

oConn.Open "Provider=MS Remote;" & _

           "Remote  Server=http://myServerName;" & _ 

           "Remote Provider=MSDASQL;" & _

           "FileDSN=file DSN Name;" & _

           "Uid=myUsername;" & _

           "Pwd=myPassword;" 





and also with 



oConn.Open "Provider=MS Remote;" & _ 

           "Remote Server=http://myServerName;" & _

        "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _

        "Data Source=c:\somepath\mydb.mdb;", _

           "admin", ""







but it is giving can not create transaction object or some thing like that.



Please help me in this regard,

All that I want is I want to connect to my MS Access Database and do ADD 

MODIFY & DELETE



Thanks in Advance



bye

venkat..

venkat_kl@y...