Re: BE on internet

StuJol wrote:
what is the possibility of putting the be on the internet?

Im thinking of putting my frontend on several PC's at different
locations and then the Backend on the website so the database can be
accessed from different locations.

Is their any known issues with doing this?

If so, when linking tables from your BE to your FE, how would you
tell your FE the BE is on a server?

You cannot link (in the way Access uses the term) to a file over the internet.
You need the abilty to actually open the file over the network and that can only
be done over the internet with a VPN tunnel. Even with a VPN the only
practical solution is to use that to run Terminal Services so that the entire
app (front and back end) are at the remote location so that all data traffic
stays on the remote LAN with only keyboard, mouse, and screen update data going
over the wire.

With a carefully crafted app that really takes every step to minimize data
traffic you could access a server based engine (like SQL Server) over the
internet, but unless that is also used via a VPN it is not considered a very
secure way to do it.

The best and most difficult thing to do is to create a web interface to your
data and not try to use Access.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.