|
Home > Archive > MS Access and Internet > October 2005 > access database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Duncan Newell 2005-10-27, 8:31 am |
| Hi,
We have an Access database ( written in access 2003 ) we would like to
publish this on our web site.
So it can be seached from the site, so a user can enter a keyword and it
will search all fields. Or just search by certain fields.
Its a quite simple database say 5 fields but 10000 records.
Our web server supports html, php and mysql, not sure how to go about this,
what is the best way ?
Thanks
Duncan
| |
| Steve Schapel 2005-10-27, 8:31 am |
| Duncan,
If the web server supports Access/Jet, you can put the database on the
web server, and then you would need to use something like ASP or ASP.Net
to build an application that will provide the user interface and data
access. The Access interface (forms etc) are not applicable in the
internet environment.
If the web server does not support Access databases, it looks like it
does support MySQL. So your choices are either to use another web
hosting service, or transfer the data from the Access database to a
MySQL database. You could do this by establishing a ODBC connection to
the MySQL database on the web server.
--
Steve Schapel, Microsoft Access MVP
Duncan Newell wrote:
> Hi,
>
> We have an Access database ( written in access 2003 ) we would like to
> publish this on our web site.
>
> So it can be seached from the site, so a user can enter a keyword and it
> will search all fields. Or just search by certain fields.
>
> Its a quite simple database say 5 fields but 10000 records.
>
> Our web server supports html, php and mysql, not sure how to go about this,
> what is the best way ?
>
> Thanks
> Duncan
>
>
| |
| Jesper Fjølner 2005-10-27, 8:31 am |
| > We have an Access database ( written in access 2003 ) we would like to
> publish this on our web site.
>
> So it can be seached from the site, so a user can enter a keyword and it
> will search all fields. Or just search by certain fields.
>
> Its a quite simple database say 5 fields but 10000 records.
>
> Our web server supports html, php and mysql, not sure how to go about
> this, what is the best way ?
If your webserver can or will support ASP, then the software ASPmaker is
pretty great http://www.hkvstore.com/aspmaker/
it creates a full set of ASP pages for creating, updating, deleting and
editing records (you can limit the options for some users). I use it to
administer a db, that runs the cms on a website.
Jesper
|
|
|
|
|