S
SheriTingle
In Access 2003 how do I save the database so it can be used on the internet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
internet?SheriTingle said:In Access 2003 how do I save the database so it can be used on the
It's not saved any differently, but you need to put it on a web server and
create a DSN to it so that IIS can talk to it through ASP pages. You can
also use ColdFusion as a web server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
A
Albert D. Kallal
You are kind of asking how does one develop software and learn how to
program (that is huge question).
When you say save database, do you mean you have some data and reports that
you want other users to be able to view and use? You can certainly output an
annual sales report from ms-access and save it as HTML. This HTML page can
then be uploaded to a web server, and everyone can view it. So, for sharing
of some data from ms-access, that is very easy. Of course, this means you
already have generated the report, and it would not be the users that are
generating this report.
However, perhaps you are talking about actually developing an application,
and then having it run via the web (ms-access is the wrong tool for this..as
it is not a web development system). You can in fact built forms and some
things that run on a web server with ms-access. (check out DAP (data access
pages) in the help. However, to run DAP, you really need to be running your
own web server (do you have your own web server that you can put software
on?). Remember, a web server is just like any other computer system. You are
now asking can you run your software on a web server. Well, the first
question is do you have a web server where you can put your software on it?
And, what kind of web server, and what kind of software does it support?
Perhaps your web server is a Apple computer, and that means your ms-access
will not run. Further, the web server might be Linux, and again, your
software will not run. So, if your web server is an Apple computer, then you
can't use ms-access. If your web server is a Microsoft server, then you can.
It is important to realize that the software you use must be compatible with
your web server. And, further, this kind of assumes that you are actually
willing to setup and run your own web server (it is actually not that hard,
but setting up security, and keeping hackers out of your network is
something that takes a LOT OF experience -- you have to know what you are
doing if you are going to expose your computer to the internet!).
As mentioned, you can certainly have ms-access generate HTML reports, and
these reports AFTER they are created can be uploaded to virtually ANY
computer that is capable of server web pages. In this case, since you are
generating the data on your computer, and then up-loading these reports to
your web server/provider, then you don't need to run the software on the web
server anymore..do you? Of course, this means your content is static.
However, if you are actually talking about running the software on the web,
that is a very big different here.
Assuming you have a web server running on your computer with ms-access, then
you can use DAP (data access pages). If you are not running your own web
server, then you will have to talk to your internet provider and ask them
what software they support and allow you to load and run on THEIR computer.
So, running some software on a web server, or learning how to write software
with ms-access is a question that is far too large for one newsgroup
question.
Note that you can have a web server consume, or read data from a ms-access
data file, but when you do this, you are only use ms-access as a system to
store data, and none of the development or programming of the software will
occur in ms-access. This kind of setup is fairly common for real small web
sites, but everything still occurs on the web server, and you don't even
have to install ms-access on the web server (since in effect you are not
using ms-access, but only the data). Typically, this set means you write the
software in asp pages, and more often today, we are seeing asp.net used to
write the web stuff.
So, you have 3 choices from above:
1) Generate static HTML reports from ms-access, and then upload them to your
web server, or internet provider of choice. You could even schedule this to
happen several time a day. This approach will work with virtually any web
provider you have, as they all support HTML, and ms-access can out reports
in HTML.
2) Put the mdb file on a web server, and then write all of the software in
ASP, or ASP.NET. This is quite common, but again, you are writing NONE of
the web based stuff in ms-access, and ms-access does not even need to be
installed on the web server. (you do have to have a provider or web server
that supports reading of JET / ms-access files). This means that the users
could request data, or you could ask them for a start/end date, and the
system would generate the report (but, that report would be written on the
server in asp..and not in ms-access).
3) Run a web server and use DAP. This means in fact you can, and do create
web pages in ms-access. This typically means you have your own computer
running a web server, and you are running ms-access on this computer.
program (that is huge question).
When you say save database, do you mean you have some data and reports that
you want other users to be able to view and use? You can certainly output an
annual sales report from ms-access and save it as HTML. This HTML page can
then be uploaded to a web server, and everyone can view it. So, for sharing
of some data from ms-access, that is very easy. Of course, this means you
already have generated the report, and it would not be the users that are
generating this report.
However, perhaps you are talking about actually developing an application,
and then having it run via the web (ms-access is the wrong tool for this..as
it is not a web development system). You can in fact built forms and some
things that run on a web server with ms-access. (check out DAP (data access
pages) in the help. However, to run DAP, you really need to be running your
own web server (do you have your own web server that you can put software
on?). Remember, a web server is just like any other computer system. You are
now asking can you run your software on a web server. Well, the first
question is do you have a web server where you can put your software on it?
And, what kind of web server, and what kind of software does it support?
Perhaps your web server is a Apple computer, and that means your ms-access
will not run. Further, the web server might be Linux, and again, your
software will not run. So, if your web server is an Apple computer, then you
can't use ms-access. If your web server is a Microsoft server, then you can.
It is important to realize that the software you use must be compatible with
your web server. And, further, this kind of assumes that you are actually
willing to setup and run your own web server (it is actually not that hard,
but setting up security, and keeping hackers out of your network is
something that takes a LOT OF experience -- you have to know what you are
doing if you are going to expose your computer to the internet!).
As mentioned, you can certainly have ms-access generate HTML reports, and
these reports AFTER they are created can be uploaded to virtually ANY
computer that is capable of server web pages. In this case, since you are
generating the data on your computer, and then up-loading these reports to
your web server/provider, then you don't need to run the software on the web
server anymore..do you? Of course, this means your content is static.
However, if you are actually talking about running the software on the web,
that is a very big different here.
Assuming you have a web server running on your computer with ms-access, then
you can use DAP (data access pages). If you are not running your own web
server, then you will have to talk to your internet provider and ask them
what software they support and allow you to load and run on THEIR computer.
So, running some software on a web server, or learning how to write software
with ms-access is a question that is far too large for one newsgroup
question.
Note that you can have a web server consume, or read data from a ms-access
data file, but when you do this, you are only use ms-access as a system to
store data, and none of the development or programming of the software will
occur in ms-access. This kind of setup is fairly common for real small web
sites, but everything still occurs on the web server, and you don't even
have to install ms-access on the web server (since in effect you are not
using ms-access, but only the data). Typically, this set means you write the
software in asp pages, and more often today, we are seeing asp.net used to
write the web stuff.
So, you have 3 choices from above:
1) Generate static HTML reports from ms-access, and then upload them to your
web server, or internet provider of choice. You could even schedule this to
happen several time a day. This approach will work with virtually any web
provider you have, as they all support HTML, and ms-access can out reports
in HTML.
2) Put the mdb file on a web server, and then write all of the software in
ASP, or ASP.NET. This is quite common, but again, you are writing NONE of
the web based stuff in ms-access, and ms-access does not even need to be
installed on the web server. (you do have to have a provider or web server
that supports reading of JET / ms-access files). This means that the users
could request data, or you could ask them for a start/end date, and the
system would generate the report (but, that report would be written on the
server in asp..and not in ms-access).
3) Run a web server and use DAP. This means in fact you can, and do create
web pages in ms-access. This typically means you have your own computer
running a web server, and you are running ms-access on this computer.