New at setting up a database

T

Tessa Ford

My client has asked me to set up a database in order to
gather information from visitors, instead of having the
information emailed directly to my client.

When I set up the form, and click on Send to Database, am I
going in the right direction? I just had a quick play with
this and it seemed to work very easily (too easily?)! And
it created an mdb file.

So, when I go to upload the change ie, the new database
file etc to the server, will the server take care of the
database? And when I go to retrieving the information from
time to time for my client, will this be an easy task to
perform and what are the steps I take to go about getting this?

As I am totally new to databases, I want to be able to
ensure I get it right first time and hope someone out there
can steer me in the right direction.

Thanks

Tessa
 
T

Thomas A. Rowe

The site must be hosted on a Windows IIS web server and have the FP extensions.

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

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

Clark

Once you have it all working and the database exists in the fpdb folder of your
website (which is, like you say, pretty easy to do, assuming you are hosted as
Tom mentioned) you are pretty much set to do what you need.

Use an ftp tool like cuteftp to transfer a copy of the database from the website
to your computer whenever you need to get it for your client. The original stays
right there on your site, being added to whenever someone fills out a new form.

Dont ftp other stuff from the website -- only the database. All other file
management / deletes etc should be done via frontpage on your pc, and then
publised to http://www.yourwebsite.com , just as was done when you originally
publish to the site.
 
T

Tessa Ford

Thanks for that. The hosts have got back to me, and they
support php files, not asp files. Is there anything I can
do on FP to create php files or not?
 
T

Thomas A. Rowe

FP will not create PHP files, however you can use FP to work with PHP files.

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

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

Tessa Ford

Thanks Tom, but how do I actually create the necessary php
files in the first place and then make it all work? Where
is the best place for me to ask/learn how to do this pretty
much step by step, which is what I need? Are you able to
do this, or do I need to find out somewhere else?

Thanks
 
T

Thomas A. Rowe

A PHP newsgroup is going to be your best resource, since you will need to learn the PHP scripting
language.

See:
http://www.php.net/

For other resources, in your IE address bar, type:

? PHP Scripting

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

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