PC Review


Reply
Thread Tools Rate Thread

Where to begin learning about datbases ?

 
 
Emmy
Guest
Posts: n/a
 
      23rd Jun 2004
Hi,

I've got an Excel file with more than three thousand records.
Each record (or line) contains the attributes of one book in eight columns
(author, name, editor, etc).
I would like my visitors to search the file asking for keywords, such as
Borges, or Spain, or Architecture, etc.
Then they would link to a page with the records that contain that specific
word (no matter in which column it is) and no other one.
Of course I will need to add and delete records but not often.

I know nothing of databases but I can manage using Frontpage 2002.
I will probably use Tripod for the hosting if they answer me that they have
ASP and IIS enabled server.

Am I supposed to use Access or can I use the Excel file ?
Where can I learn about this ? I've been looking in the Help within FP but I
don't like it, it's not clear enough.
Thanks in advance !

Emmy


 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      23rd Jun 2004
1. Tripod is not going to be able to handle this as they run Unix/Linux servers which do not allow
the use of ASP or Access.

2. You want a Windows based web host that supports Access with the ability to upgrade at some point
to MS SQL server.

3. You would want to use Access, not Excel.

4. You will need to be willing to learn to code in ASP/VBScript, as you can start out using the FP
database components, but will find that is has limitations, as your needs grow, and they will once
you see what a database driven web site can do.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Emmy" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hi,
>
> I've got an Excel file with more than three thousand records.
> Each record (or line) contains the attributes of one book in eight columns
> (author, name, editor, etc).
> I would like my visitors to search the file asking for keywords, such as
> Borges, or Spain, or Architecture, etc.
> Then they would link to a page with the records that contain that specific
> word (no matter in which column it is) and no other one.
> Of course I will need to add and delete records but not often.
>
> I know nothing of databases but I can manage using Frontpage 2002.
> I will probably use Tripod for the hosting if they answer me that they have
> ASP and IIS enabled server.
>
> Am I supposed to use Access or can I use the Excel file ?
> Where can I learn about this ? I've been looking in the Help within FP but I
> don't like it, it's not clear enough.
> Thanks in advance !
>
> Emmy
>
>



 
Reply With Quote
 
Emmy
Guest
Posts: n/a
 
      23rd Jun 2004
It seems more difficult than what I was thinking on !

My English is not so good...you meant that I could start using FP database
components, but then I will need to code in ASP/VBScript, as my database
grows ...?
And if I want to do it that way, where can I learn how to use FP database
components ?

Thanks for all !
Emmy


 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      23rd Jun 2004
Emmy,

Yes, you could start with the FP Database component, do search under help. As your site grows, as
well as your needs, you will need to learn ASP/VBScript so that you can code some of the function
directly that FP's database component doesn't support or doesn't handle well.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Emmy" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> It seems more difficult than what I was thinking on !
>
> My English is not so good...you meant that I could start using FP database
> components, but then I will need to code in ASP/VBScript, as my database
> grows ...?
> And if I want to do it that way, where can I learn how to use FP database
> components ?
>
> Thanks for all !
> Emmy
>
>



 
Reply With Quote
 
Emmy
Guest
Posts: n/a
 
      23rd Jun 2004
Thanks for your answer Thomas !
but don't forget to tell me where can I start learning FP database
components ?

Emmy


 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      23rd Jun 2004
FP Help.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Emmy" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> Thanks for your answer Thomas !
> but don't forget to tell me where can I start learning FP database
> components ?
>
> Emmy
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where to begin learning how to make 'Ajaxify' your own code? darrel Microsoft ASP .NET 1 31st Jan 2007 07:42 AM
Recordsets and datbases =?Utf-8?B?U3RldmVu?= Microsoft Access VBA Modules 1 8th Oct 2006 09:10 AM
Newbie to begin learning about application packaging zcarenow@yahoo.com Microsoft Windows 2000 MSI 0 2nd Oct 2005 02:03 AM
Not sure where to begin =?Utf-8?B?VmVyb25pY2E=?= Windows XP Help 13 20th May 2005 01:43 AM
problem with 2002 to 2003 datbases ChrisDUBBY Microsoft Access 0 10th Mar 2004 06:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:03 AM.