Here I go again with a related question!  Similar to Andrew, I am a beginner
when it comes to databases.  One of my projects is to build a knowledge base
on our company intranet, for documents relating to a global company-wide
project.  I am beginner-to-intermediate with ASP, but I do not know VB at
all (save for some VBScript, which I know is related, but different).

I was thinking I could use ASP and XML (also a beginner at this) to create
the searchable knowledge base.  Hank, you mention below that Access is not
what you'd use.  I don't know what I'd use, so what is your suggestion?  I
was initially thinking of Excel as a database of the documents.

Any thoughts would be appreciated.

TIA,

Maureen


-----Original Message-----
From: Hank Marquardt [mailto:hmarq(at)yerpso.net] 
Sent: Thursday, January 24, 2002 9:54 AM
To: Andrew Armstrong
Cc: hwg-techniques(at)hwg.org
Subject: Re: Web pages from a database


Hi Andrew, you really want something like PHP or ASP here -- you'd have
*one* page that you'd pass something like a museumID ... that page would
have database hooks in it to get that particular record and show the page.

Access is definitely not what I'd use, but you said you have no choice in
that matter -- no VB needed -- unless I've completely misread the request,
you are posting on the Web, correct?

On Thu, Jan 24, 2002 at 11:54:57AM -0000, Andrew Armstrong wrote:
> I have been asked to tender for a job where some pages are to be 
> generated from information held in an Access database. I don't have 
> any choice about the database - it will simply hold information about 
> museums - opening times, address, contact details and so on.
> 
> The plan is that every time that the database is updated, someone can 
> carry out a siomple procedure to generate new copies of the 
> information pages for the specific museums.
> 
> Has anyone any ideas? I have limited database experience, and am just 
> starting to learn Visual Basic. My guess is that I need to make a 
> template, then to write a Visual Basic program to query the database 
> and place information in the template at the appropriate point.  In 
> order to do this I would clearly have to learn some more stuff, so if 
> it isn't the best approach I don't want to waste too much time.
> 
> If I do need to learn more about databases and Visual Basic, I would 
> appreciate any pointers as to what to concentrate on first so I don't 
> spend a long time floundering around.
> 
> Andy

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA