Database

J

Joe

I need to create a dbase for many recipes and I am new to this. What program
should I use to create this that will work with FP03? Access? Then will I
need any other services on my host other than 02 extensions? Thanks in
advance !!!!!
 
P

Paul M

Hi Joe
Access should be fine. Although if you think you will be getting thousands
of hits a day ie. more than 255 people accessing the database at anyone time
then you will probably want to use a SQL database but I would use access to
start off with. I use access it with the same setup as you are.
A good way that I have found to create the database is to first create a
form in FP to input the information ie.recipies and the such into the
database. When you are happy with the fields of the form right click the
form select connect to a database, then in options select create database.
FP will then create a database using the fields from your form. in another
page you can then use the database results wizard to create a search query
and form so that people can search by key words and the such for a recipy.
Then you you can access the online database by using the database interface
wizard were you can change the contents of the database.
Best wishes
Paul M
 
J

JDR

Joe,

Access is the best choice.

Your server will require support of .asp or .Net (Depending on your
choice), if your on a Unix based system, don't even attempt this.

Here is a link to more detailed information on getting started:
http://office.microsoft.com/en-us/assistance/CH063547611033.aspx

Remeber that you are creating dynamic content, so if you develop this
locally (which is fine), you will need to upload the files to the server for
testing and functionality.

JDR
********************
 
A

Andrew Murray

you will need a host with 1) Windows server 2) FP server ext 3) ASP. 4) IIS. 5)
Allows Access DB's.
 
T

Thomas A. Rowe

An Access based web site can handle at least 6000 users per hour, however it depends on how the
ASP/VBScript is coded by hand and you are not using the FP database components.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top