Accessing a database on a remote server

[rael_lucid]

Hi,
A client of mine has an website which has a MS Access backend. The site is
hosted by a third party company.
I am building a solution for them that needs to "share" data with the
website backend. I am unable to connect to the webserver through a VPN or
similar.
Is it possible to set up an ODBC connection using the remote IP address of
the webserver and port forwarding?

Rael

 

[punjab_tom]

Access MDB is for fucking retards.

Anyone that uses it for _ANYTHING_ is not someone you want to do
business with.

Terminate your relationship with them and then spit on them.

-Tom

 

[Damian S]

Hi rael,

Probably possible in some way, shape or form, but not advisable. What are
you trying to achieve?

Damian.

 

[Albert D. Kallal]

Is it possible to set up an ODBC connection using the remote IP address of

the webserver and port forwarding?

If you dump the mdb for the back end, and use sql server (or whatever
database server
the provider has), then this
can work. You can't connect to a mdb file on that server, because you
actually need to open the file
ACROSS the internet. The internet does NOT support windows networking OVER
the internet, and you need to physically open that file on the hard drive
sitting on that server (thus, you would have to use a vpn..as that DOES get
you networking over the internet).

However, it would be too slow anyway...about 100 times to slow.

There are some solutions outlined here:

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

 

[rael_lucid]

My client has a webstore which has a MS Access database backend.
I have written them a backoffice inventory management application. Looking
at performing some type of data synchronisation between the two databases
(stock on hand, new sales etc).

According to other posts, the suggested method is to upgrade the webstore to
SQL server or similar. I think this is what I am going to recommend to my
client. I think that fiddling around with creative ways of doing it in Access
will most likely end in frustration for the client and lost billable time for
me.

Rael

 

[punjab_tom]

yes; that is right

Acccess isn't reliable enough for real world use; it doesn't support
encryption; it doesn't even support security


keep your data in one place; on a database server