putting the BE on the web

A

amy navarro

I ahve successfully split my database. I want to put the BE on some web
space we have and use that as the server. (it is the free space that comes
with earthlink accounts) How do I get Access FE to point to the right place
to find the BE?

this is where I want it to find the backend at:
http://home.earthlink.net/~amyatthompson/data/time be.mdb

Can it be done or do I need to do something different?

amy
 
A

Albert D. Kallal

You *could* in theory do this if your hosting provider would all a vpn
connection, and let you browse that folder on the server.

However, most providers do NOT allow you VPN access to their servers,and
allow you to browse their folders. (if they did, then in theory via a secure
VPN you could link to the back end, however, all users of the system would
have to be proved with specific rights on a per user bases).

Of course, the other problem with the above is the connection is about 100
times too slow. You can read up how this works, and some solutions here:

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

J. Clay

You don't.

Access does not work over broadband. It is designed to work over a LAN
which is at least 10 - 100 times faster than a fast broadband connection.
Search on this NG, there is a linke to a very good explaination of this that
is posted at least a couple of times per week.

The only way to use access from the web is to have it on a web server
running some type of scripting language such as ASP.NET.

Jim
 
M

[MVP] S.Clark

Can't be done in that fashion. The Access UI can't access it via http.

You can use ASP as a front end to the database.
 
A

amy navarro

First off I DID search this site for answers and found a couple but not
exactly what I was asking. I don't like to wait for answers so if I can find
them already posted all the better. I figured someone would have asked this
by now.

What I am understanding is that I can't do what I want to do more because I
would have to use a http and Access can't do that. Earthlink already has
folders set up for each accout
(http://home.earthlink.net/~amyatthompson/data/time be.mdb) DATA is the
folder they set up by default. I can put more folders on the webspace if I
want.

I have put another Access file (entire thing) on the site and can use it.
Can it have mulitple users that way? If several of us are on it at the same
time will it work alright and just be slow?

If I set up a server in the office and put the BE on it could people login
from outside the office to use it or would that still require ASP? What if we
used something like PC Anywhere for the person outside the office?

Amy
 
J

J. Clay

Amy, I suggest you read the link in Albert's response. I have included it
below. This is a link I have seen posted several times regarding this
question.

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

The primary reason you should not try and use an Access database over the
internet is the speed of the connection which 1) causes the database to load
VERY slowly and 2) because of the latency involved, pretty much guarantees
corruption.

If you want people from outside of the office to be able to use your
database, then yes, something like PC Anywhere would work. A better
solution would be Terminal Services or Citrix as this allow multiple logins
to the some server where as PC Anywhere requires a machine available for
each person that need to get in from the outside.

If, on the otherhand, you have the resources and are willing to use a web
interface, ASP or the current technology ASP.NET is perfectly acceptable. I
have several web site that are run off of an Access database.

HTH,
J. Clay
 
A

Albert D. Kallal

I have put another Access file (entire thing) on the site and can use it.
Can it have mulitple users that way? If several of us are on it at the
same
time will it work alright and just be slow?
Click to expand...

No, when you click on that link, the mdb file is first downloaded to YOUR
computer, and then opened. So, you can use the file this way, but any
changes you make will be to the copy that just got downloaded to your
computer. Anyone clicking on the web link again will download the original
copy. I suppose after you are done editing the file on your local computer,
then you could upload it..but then that would overwrite any changes any
other uses made.
If I set up a server in the office and put the BE on it could people login
from outside the office to use it or would that still require ASP? What if
we
used something like PC Anywhere for the person outside the office?
Click to expand...

Yes, you could use something like PC anywhere, but now windows has remote
desktop built in, so you don't need pc anywhere now. I mentioned this
concept as a possible solution in my other "link".
 
Top