Access on the web

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I'm not sure if this is the right place for this question
but here goes......

Is it possible to publish an Access form to a web site
for people to input data and have it saved to a db
residing on the server? If so, what additional software
is required if any and are there any additional licences
needed to have multiple people access it via the web to
input data? The reason behind this is a small survey for
my company and we don't want to have to mail paper copies
around the country.

Thanks in advance for any advice.

Todd
 
Todd:

As an example of what can be done, go to a site I made for a friend ...
http://www.amazecreations.com/survey/Login.asp

To login, select Admin (all) as the region, Danny Lesandrini as the user and
123456 for a password. This page (and subsequent pages) look up data in
Access tables to create the drop down lists. I even use them in updateable
fields. Click the Edit Tables link and click on Offices for an example.

If this fits your needs, I'll forward the code to you, though I didn't
write it with the idea of anyone looking at it, and comments may be sparce.
 
Hi,

You can use Access as database for a web application written in almost any
web development environment (ASP, ASP.NET, PHP)
ASP is shipped with IIS, the web server available on any Win2000/XP Pc (and
even on Win98, there it is called PWS - Personal Web Server - it is a
limited version of IIS). You don't need any additional license to use it.
ASP.NET is part of NET Framework, the next generation programming
environment from MS. It is already available on WinXP, Windows NET server
2003, and can be freely downloaded and installed on older MS OS (like
Win2000 Server or Professional)
PHP is a free server side scripting language, which also can be freely
downloaded and installed on IIS.

However, the most used environment is ASP or (lately) ASP.NET

But you cannot simply put your Access form on one of those two platforms.
You need to write a ASP or ASP.NET app application, which will use web
pages (for web forms embedded in those web pages) to collect data from users
and save it to Access database.

If you need any more info about any of those options, you can contact me
directly.

Regards,
Bogdan Zamfir
 
Back
Top