How to Connect to database on a server using VBScript located on different server?

Discussion in 'Programming' started by sagargemini, Jul 30, 2007.

  1. #1
    Hi friends,

    I am in deep trouble. :( I want to connect to MS Access database on a server using VBScript located on entirely different server. But I am unable to do so. Can someone please help me out?? Many thanks in advance!
     
    sagargemini, Jul 30, 2007 IP
  2. dizzy

    dizzy Peon

    Messages:
    43
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I don't think that's possible. If it was on a SQL server you could, but not with MS Access.

    The alternative is to build a webservice on the other server that has queries & update methods and you could connect to the webservice on your server.
     
    dizzy, Jul 31, 2007 IP