Access a MSACCESS database from a webpage

[Guest]

I run Win98 using a freeware webserver which does not have a lot of bells and
whistles but works great for what I'm doing.

I have an Access 2003 database that contains a list of over 40000 addresses.
I would like to make this database accessible over the Internet using a
webpage.

I'm a freelance programming nut and would like to find something that will
work.

Any suggestions of where to start looking would be appreciated. I'm doing
this on my own and can't afford the expensive of more advanced software and
web servers.

All I need is to be able to retreive data from the database to display on a
webpage. No data needs to be put into the database. ie: Read only function
with lookup capability.

Have a great day.

 

[Ed Warren]

David,
Your are going to need at least a little bell and/or 'tooter' of a whistle
on your server.

The server will have to send a query to the Access database and return data
in some usable format.

In the microsoft world this is normally done via ado (active data ojbects),
in ASP (active server pages) or the newer ado.net (active data objects .net)
and asp.net (active server pages .net), using a windows server (IIS).

How you get from where you are to where you want to be is a matter of what
technology you want/can implement. (java server pages, asp, asp.net, xml,
other scripting languages)

You may want to investigate MySQL as a database engine (www.mysql.com)

Best of Luck

Ed Warren

 

[Guest]

database that contains a list of over 40000 addresses. I would like to
make this database accessible over the Internet using a webpage.<<

Are you sure you want this database on the internet?

In Peace,

Max

 

[Guest]

Hello Warren

I was assuming that a little more 'punch' would be required. I have thought
about putting NT4 Server online or going with Suse Linux and Apache. I'm just
not sure I'm ready for that bold of a move.

I spend about 6 months of the year in limbo waiting for the football season
to start and then I out of touch with the computer world.

The rate I go, what is current today may end up being replaced 6 months
later but I want to at least get a start.

I thank you for the reply and will consider your recommendations.

David,
Your are going to need at least a little bell and/or 'tooter' of a whistle
on your server.

The server will have to send a query to the Access database and return data
in some usable format.

In the microsoft world this is normally done via ado (active data ojbects),
in ASP (active server pages) or the newer ado.net (active data objects .net)
and asp.net (active server pages .net), using a windows server (IIS).

How you get from where you are to where you want to be is a matter of what
technology you want/can implement. (java server pages, asp, asp.net, xml,
other scripting languages)

You may want to investigate MySQL as a database engine (www.mysql.com)

Best of Luck

Ed Warren

 

[Guest]

The 40000 addresses are already available in a fixed length format text file
on the Internet anyway, I'm just looking at making a more 'user friendly'
access method to that data.

Thanks for the reply.

 

[Brian]

Hello Warren

I was assuming that a little more 'punch' would be required. I have thought
about putting NT4 Server online or going with Suse Linux and Apache. I'm just
not sure I'm ready for that bold of a move.

I spend about 6 months of the year in limbo waiting for the football season
to start and then I out of touch with the computer world.

The rate I go, what is current today may end up being replaced 6 months
later but I want to at least get a start.

I thank you for the reply and will consider your recommendations.

Whether more "punch" is required will depend on how may hits your
site/database gets. Access is entirely unsuitable for a busy website,
consider MySQL.

Why NT4? Anyway, I imagine (but I'm not sure) that NT4 includes IIS, so
there's a web server for you. Or, if you want Apache, you can get a Windows
version (although I'm not sure about support for the older Windows versions
you are mentioning).

If you finish up with IIS, you can use ASP to access your database. If
Apache, you can use the far superior PHP (which has very straightforward
support for MySQL built-in).

But why are you running your own web server anyway? The smart move would be
to do what everyone else does, which is to get someone to host it. This is
very, very cheap these days. If you do this, then the PHP/MySQL route would
be the best way to go.