Connect to Remote Access Server

[Altair Brito]

Hello everyone

How would I go about connecting to an Access DB that's on another network?
For instance, I have the DB on my web server that you can add files to, what
would be the connection string for VB to get data from that file..?

To access a locally db I used:

DBPath= App.path & "\db\db.mdb"

CN.open "Provider=Microsft.Jet.OLEDB.4.0;Data Source=" & DBPath & "; Persist
Security Info=False;Jet OLEDBatabase Password:1234"

Thank you for you help!

 

[Tom van Stiphout]

On Thu, 21 May 2009 10:39:50 +0000, Altair Brito

You can't. If the only access to that db is via HTTP, then you can't
because Access cannot work over this protocol. It only works over SMB
which means you have to be on the same LAN.
In some cases you can use Terminal Server to run a session on that
remote network, and then work there to access the db.
Or you can write a web application (which *can* work over HTTP) to
update the data in the Access db.

-Tom.
Microsoft Access MVP

 

[David W. Fenton]

Or you can write a web application (which *can* work over HTTP) to
update the data in the Access db.

You mean in the *Jet* db, as there is no part of Access that will be
of use in that scenario.

 

[Tom van Stiphout]

On 21 May 2009 12:54:23 GMT, "David W. Fenton"

Yes of course. I used the term "Access db" (too) loosely.

MsAccess front-end against a SQL Server back-end at some ISP can work,
although I have never used that configuration for serious production
work, only for simple maintenance tasks.

-Tom.
Microsoft Access MVP

 

[Douglas J. Steele]

As far as I know, you cannot use the http: protocol (nor the ftp: protocol)
to connect to a Jet database. If you cannot use UNC, then you're out of
luck.

 

[Albert D. Kallal]

Hello everyone

How would I go about connecting to an Access DB that's on another network?
For instance, I have the DB on my web server that you can add files to,
what
would be the connection string for VB to get data from that file..?

To access a locally db I used:

DBPath= App.path & "\db\db.mdb"

CN.open "Provider=Microsft.Jet.OLEDB.4.0;Data Source=" & DBPath & ";
Persist
Security Info=False;Jet OLEDBatabase Password:1234"

Thank you for you help!

The "path" name has to be legal windows path name. You could in theory setup
a VPN connection (if the web server/hosting allows this). You would then
have a disk drive mapped a z: or whatever, and that disk drive would
actually reside on the server. However, even if you did get a VPN running,
you still would run into problems. I explain these problems (and give some
solutions) in trying to run ms-access "over" the internet here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html