Results 1 to 6 of 6

Thread: Remote access to MDB from DESKTOP

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2002
    Location
    IND
    Posts
    2

    Question Remote access to MDB from DESKTOP

    Hello all,

    I have gone thru almost all the replies on this forum for
    this issue "how to access MDB on a web server , from a desktop"

    but found no solution and at mylevel tried to give the connectionstring in different ways like:

    oconn.Open "Provider = MS Remote;" _
    & "Remote Server = http://www.mysite.com;" _
    & "Remote Provider = Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source = C:\dbpath.mdb;admin,"


    oconn.Open "Provider=MS Remote;" & _
    "Remote Server=http://myserverIP;" & _
    "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:\dbpath.mdb;", _
    "", ""

    oconn.Open "Provider=MS Remote;" & _
    "Remote Server=http://myserverIP;" & _
    "Remote Provider=MSDASQL;" & _
    "DSN=dsnname;"

    (i guess the MSDASQL is for Sql server, isn't it?)


    oconn.Open "Provider=MS Remote;" & _
    "Remote Server=http://ServerIP;" & _
    "Remote Provider=Microsoft.jet.oledb.4.0;" & _
    "Data Source=dsnname;"

    but no results.



    I want to access a MDB on the web server from my desktop using
    Visual Basic
    Pls,pls if anyone has the working code please mail me
    at technofriend@indiya.com
    i would be very greatful.

    NOTE: i want the solution to read only MDB not SQL server.

    thank you very much all, in advance
    sincerely yours
    hassan ali

    Expression is Life

  2. #2
    New Member
    Join Date
    Apr 2020
    Posts
    2

    Remote access to MDB from DESKTOP

    Quote Originally Posted by hassan_ali View Post
    Hello all,

    I have gone thru almost all the replies on this forum for
    this issue "how to access MDB on a web server , from a desktop"

    but found no solution and at mylevel tried to give the connectionstring in different ways like:

    oconn.Open "Provider = MS Remote;" _
    & "Remote Server = http://www.mysite.com;" _
    & "Remote Provider = Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source = C:\dbpath.mdb;admin,"


    oconn.Open "Provider=MS Remote;" & _
    "Remote Server=http://myserverIP;" & _
    "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:\dbpath.mdb;", _
    "", ""

    oconn.Open "Provider=MS Remote;" & _
    "Remote Server=http://myserverIP;" & _
    "Remote Provider=MSDASQL;" & _
    "DSN=dsnname;"

    (i guess the MSDASQL is for Sql server, isn't it?)


    oconn.Open "Provider=MS Remote;" & _
    "Remote Server=http://ServerIP;" & _
    "Remote Provider=Microsoft.jet.oledb.4.0;" & _
    "Data Source=dsnname;"

    but no results.



    I want to access a MDB on the web server from my desktop using
    Visual Basic
    Pls,pls if anyone has the working code please mail me
    at technofriend@indiya.com
    i would be very greatful.

    NOTE: i want the solution to read only MDB not SQL server.

    thank you very much all, in advance
    sincerely yours
    hassan ali

    Hi,
    I'm trying to do the same thing, and also trying lots of variations; did you solve it?

    M.

  3. #3
    Administrator Steve R Jones's Avatar
    Join Date
    Apr 2012
    Location
    Largo, FL.
    Posts
    1,569

    Re: Remote access to MDB from DESKTOP

    LivingInfo Systems - this thread is TWENTY YEARS OLD.

    The last time you posted was to a FIFTEEN year old thread.

    Is there a reason?
    Wi-fi went down for five minutes, so I had to talk to my family....They seem like nice people.

  4. #4
    Addicted Member jg.sa's Avatar
    Join Date
    Nov 2017
    Location
    South Australia ( SA )
    Posts
    191

    Re: Remote access to MDB from DESKTOP

    G'Day SRJ

    I would dust off and nuke the guy !!!

    Give him a chance to "Get 2 the chopper"

  5. #5
    PowerPoster
    Join Date
    Feb 2006
    Posts
    23,887

    Re: Remote access to MDB from DESKTOP

    Remoting Provider is obsolete. Mainly due to security issues from poor administration much of its support infrastructure was deprecated and isn't even shipping in Windows any more.

    Even when it was viable it required special programming considerations if updating was to be done.

    Thus both programmers and DBAs failed hard trying to use it.

    The suggested alternative was to move to an application specific web service model, since generic access was the root of the security woes when blind defaulting was used with Remoting. So instead of learning a little bit to make it work safely, you had to learn a lot and do a lot of custom coding on both client and server.

  6. #6
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    37,861

    Re: Remote access to MDB from DESKTOP

    There has also always been an issue with sharing an Access database over a network. Any interruption, no matter how temporary, while you have the connection established, will almost certainly result in your database becoming corrupted in seemingly unpredictable ways. I've had individual records scrambled, tables scrambled, and an entire database that got locked in such a way that it couldn't be used by anybody in any fashion, and Windows even refused to allow it being deleted. It lived in that state for years, until the drive it was on was reformatted.

    If you want to do database work across a network, Access is not the right choice.
    My usual boring signature: Nothing

Posting Permissions

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



Click Here to Expand Forum to Full Width