Access database and website queries

[Cast-it Admin]

I am a complete novice to Access (and any other database).

I produce an industry newsletter 2 or 3 times a week, I have a website onto
which I want to be able to somehow include a database that would allow my
subscribers to look up and view past issues (produce in MS Word) but I
haven't the first idea of how I would go about this.

I am using MS Frontpage 2003 to build the site and following the instruction
in various books they all assume that the database you want to include is a
straightford names & address look-up - I need to somehow link to Word
documents and preferrably give site visitors the option of being able to
search for specific articles or products named.

Is this all too complex for a newbie?

Rob

 

[Guest]

Is this all too complex for a newbie?

Probably, but you won't learn how to do it unless you try. To link to Word
documents, create a Hyperlink field in the database table and place the path
and file name in this field. To find out how to get a Frontpage-created Web
site to search the tables, you should ask in the Frontpage discussion group.
(If it were me, I would use ASP to access the data, but you probably don't
know ASP which is why you're using Frontpage.)

If you have too much trouble, hire someone to do it for you. It's faster
and usually cheaper to hire an expert. If you don't think it's cheaper, how
much is your time worth where you could be doing productive work instead of
trying to create a Web-based database for the first time?

Chris Mills
Your Access Resource

http://www.accessresource.somee.com/Specials.html

 

[nanne]

I have the same problem. I solved it as follows.
All articles are transformed into PDF-files to be opened with Acrobat
Reader.
Links to the pdf-files are placed on the site,
It is much easier.

regards

Nanne