beginner Access question

Ladies and gents -

I'm a newbie at DB design using Access 2000 and have a simple question. Here is what I want to accomplish:

I've already put together a simple DB that will hold appr 2000 records, each record containing appr 40 fields. I want to be able to pull the info from a single record (name, address, zip, phone, etc.) out of the DB, incorporate it into an html template, and publish it to a web site. I'm not interested in putting the entire DB on the web - I want to control the info that is dispersed to my web visitors.

What is the best way to do this?

All suggestions are sincerely appreciated!

I don't quite understand the limitations you have. A typical scenario would be to locate the mdb on your web server and use asp, php or some other server-side code to dynamically generate whatever html should go to the client browser.

Doug -

Thanks for your reply. Keeping my rookie status in mind, are there software tools that will help me accompish what you have suggested? I use Frontpage 98 for my website and am designing an Access 2000 DB. Is there an easier way to accomplish my objective (MySQL maybe?)

Thanks!

I don't know of any easy GUI tools for creating dynamic pages, except maybe ASP.NET? Personally I would use PHP (because its free and easy). As far as DB design goes, it doesn't get much easier than MS Access. If you want to learn how to get a dynamic page up and running I highly recommend the visual quickstart guide: PHP for the World Wide Web, which can be found HERE. Online tutorials help out a lot, but I've always found that having a book makes it painless and a lot faster. Hope that helps.

There are a couple of third party tools you can use to generate ASP or PHP pages.

Heres two:

http://www.hkvstore.com/aspmaker/

http://www.citybusinesslogic.com/apwab.php

I appreciate the replys. Looks like I should go with a MySQL DB and PHP.


...off to do some learnin'