You should use a much better subject line for your question.
There is likely hundreds of people who are viewing this newsgroup, and
simply passed over your question. Those 100's of users are likely VERY many
that have experience in setting up web sites with ms-access. However, most
people here are quite busy...and you missed a real golden opportunity to get
a lot of people to answer your question.
Most busy (and intelligent) people don't simply open up all the messages
here in this newsgroup...but simply skin the subject text. When they see a
question that they might be able to contribute to..THEN the message is read.
So, all those skimmers with good knowledge about ms-access and a web site
likely skipped your question...since the subject line was poorly done.
But here goes,
I have started a website and I am thinking of using Access
to store infomation. I have seen several posts here where
people are using Access to drive an intranet based
solution.
Actually, it not access you need, but the JET database engine that ships
with ms-access.
So, that web site can connect to a mdb file, but you don't need or use
ms-access on that web site (you use he JET database engine that connects to
the mdb file).
What I want to know is it possible to upload AccessDB and
data access pages to my site, then have the users enter
and view the data or would I have to 'host' the db myself
(impractical as I'm on a dailup)
You most certainly can use a mdb file for your data store, but your internet
provider will then have to support and have installed the ability to read
mdb files for you. Some providers will install and setup the JET database
engine. However, since it is just a data store and your interface is web,
then you don't really need ms-access...do you?
Normally, most internet providers want you to use sql server, or some other
mainstream database system to store the data. Ms-access works equally well
with sql server, or the JET database engine (the default one). So, in
theory, you could continue to use your ms-access application, but use a
different database engine then JET (once again, JET is the engine that is
used for mdb files, but ms-access lets you choose different database
engines. Ms-access is NOT a database, but only a tool to build a interface
to a database engine of choice. By the way, a web site can also connect to a
database engine of your choice also).
So, if your provider does support "JET" database engine, then you can put a
the mdb file on your web site and connect to it. However, your providers
does NOT need to install ms-access on the web server (and that would not
work, or be of use to anyone anyway!).
Likely, your provider supports main stream database engines. However, a few
do support JET database. Of course, if you setup and run your own server,
then you can choose whatever database engine you (or your budget) will
allow.
So, just like ms-access can connect to JET, or MS sql server, or Oracle, or
MySql, the same thing applies to your web site (or provider). You need to
find out what database engines your providers supports.
So, ms-access can connect to a database engine, and so can your web site. As
to what database engine you want to use..that is going to depend on which
systems your provider supports.
