You're almost certainly using Windows, so you can set up your PC as a Personal Web Server (look in Windows Help for details) and then use ASP to build your web pages from the database (look on the Internet for heaps of ASP tutorials). Good luck, and don't be scared - it's not as difficult as it first looks!

Trimm,
If I understand your objective correctly, I recently had a similar request. Remote users (very remote as it turns out) needed to get at a dynamically produced web site without internet connectivity. So we wanted to recreate the site as static pages on a cd/dvd.

I thought about a several aproaches: Using VB to read the database and write out static pages (merging dynamic data in with static html templates); Using one of the tools that will crawl and save off an entire site (a site stealer of sorts); and having someone manually go through each page with a browser, saving the HTML to disk page by page.

Not sure whether my project will ever materialize, and that's all the thinking I've done on it so far.

Ross

As Purple Martin says, ASP will work.

.... Shane

Hi Trimm,

If memory serves me right, there is a tool build into Access which allows you to serve up dynamic webpages.

If your site is going to be really busy, using access online is generally not a great idea as it gets bogged down under a lot of hits.

You could try php/mysql?

Other than that, I came across a decent asp tool last year. its called aspwizard.It should make your job a little easier.

Kind Regards,
Barry

Hi trimm,

Sorry, in my haste, i read your question wrong....you just want static web pages.
Theres definitely a tool build into access to do this.

For example, access can create a query and send the results into a web page all in the click of a button.
I think the only draw back is your users have to be using I.E. to read the html files.I suppose it would be perfect for an Intranet

Blessings,
Barry

I currently use DBtoWEB to merge MS Access field data to a HTML template file. The syntax takes a little getting used to, but if you know ASP or ColdFusion - it should be pretty easy to pick up.

WebMerge is another - more slick - mo' money.

I've been using WebMerge and I love it. Very slick, easy to use and outputs SE friendly static html.

Thank you all very much. I'm reading through WebMerge's instructions and it looks the perfect thing.

Thanks all and have a good weekend