Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2009
    Posts
    5

    Question Unanswered: How to remote qurey the Access DB

    Hi Guys,

    I am new to SQL.

    I am trying to remotely access the Access database, but i could not do it

    I could successfully able to retrieve data from Access database (situated locally), using following query!!!!
    OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=C:\db1.mdb')...Table1

    But the problem here is .... I should be able to get data from remote MS-Access. I mean like providing IP address or something like that.

    I am struggling from 4 days, please somebody help me!!!!

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    what do you mean by remote? same network? over the internet?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jul 2009
    Posts
    5
    Quote Originally Posted by Thrasymachus
    what do you mean by remote? same network? over the internet?
    Same network!!!!!!!!

    From my system (where SQL server is present) to another system (in same network).

    Could we use OPENDATASOURCE with IP address of the system (which contains MS-Access db)?

    Please let me know?????????

  4. #4
    Join Date
    Jul 2009
    Posts
    5
    can anybody please help me on this......

  5. #5
    Join Date
    Mar 2009
    Posts
    349
    how how abou this...

    OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=\\MachineNameOfRemoteComputer\ShareName\db1.mdb')

    the part in bold you will have to fill in yourself.

  6. #6
    Join Date
    Jul 2009
    Posts
    5

    Smile Thanks Thrasy

    I don't know how to appreciate you, Thrasy

    Really thanks!!!!!! A lot

    (Past) I really tried in and out
    But failed...... I was trying for it for more than 2 weeks. Now i got the result (answer)

    I can not really explain in words .... I am out of a gr8 mental tension.

    Really thanks for that Thrasy.

    Thanks again, it worked for me!!!!!!!!!!!!!!!!!!!!!!

    Thanks,
    Praveen

Posting Permissions

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