Retrieve & update data against remote database
-
I am developing an Access 2000 database application. In my application, I need to connect to a remote Access 2000 database to retrieve and update data. I tried to use RDS (Remote Data Service) as mentioned in MSDN but failed (it raised a runtime error 8447: Internet Server Error). Dim cn as ADODB.Connection Dim rs as ADODB.Recordset cn.Open "Provider=MS Remote; Remote Server=http://myServer; Data Source=sample.mdb" Set rs = cn.Execute(mySelect) Do I need any configurations on the server to make the above code work? Or are there any way else? Please help me, thanks. Lan hue sau ai lan hue heo Lan hue sau doi trong heo ngoai tuoi
-
I am developing an Access 2000 database application. In my application, I need to connect to a remote Access 2000 database to retrieve and update data. I tried to use RDS (Remote Data Service) as mentioned in MSDN but failed (it raised a runtime error 8447: Internet Server Error). Dim cn as ADODB.Connection Dim rs as ADODB.Recordset cn.Open "Provider=MS Remote; Remote Server=http://myServer; Data Source=sample.mdb" Set rs = cn.Execute(mySelect) Do I need any configurations on the server to make the above code work? Or are there any way else? Please help me, thanks. Lan hue sau ai lan hue heo Lan hue sau doi trong heo ngoai tuoi
hi there, this article might give u a hint on this Remote DB Access << >>
-
hi there, this article might give u a hint on this Remote DB Access << >>