Remote Machine Access

Results 1 to 2 of 2

Thread: Remote Machine Access

  1. #1
    Join Date
    Dec 1969

    Default Remote Machine Access

    &nbsp;<BR>Suppose i want to access an MS Access DB on a remote Machine how do i do it...Is there any piece of code that i have to stick??<BR>Please Let me know...

  2. #2 Guest

    Default RE: Remote Machine Access

    set Conn=server.createobject("adodb.connection")<BR>co nn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=" & server.mappath("/dbpath/mydb.mdb") & ";"<BR><BR>set rs=server.createobject("adodb.recordset")<BR>rs.op en "select * from mytable", Conn,2,3,1<BR>do while not rs.eof<BR>&#039 do something to the fields in current row<BR>rs.movenext<BR>loop

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts