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





__________________________________________________

Do You Yahoo!?

Buy the perfect holiday gifts at Yahoo! Shopping.

http://shopping.yahoo.com