Remote access to MDB from DESKTOP

[hassan_ali]

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

[LivingInfo Systems]

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.

[Steve R Jones]

LivingInfo Systems - this thread is TWENTY YEARS OLD.

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

Is there a reason?

[jg.sa]

G'Day SRJ

I would dust off and nuke the guy !!!

Give him a chance to "Get 2 the chopper"

[dilettante]

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.

[Shaggy Hiker]

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.