New at setting up a database

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

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)
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

"Tessa Ford" <info@webford.co.nz> wrote in message news:02d401c51634$09a9ca80$a401280a@phx.gbl...
> 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

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.

On Fri, 18 Feb 2005 19:35:20 -0800, "Tessa Ford" <info@webford.co.nz> wrote:

>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

You can also open the live web in FrontPage and use the File | Export
command to download the database to your hard drive.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



"Clark" <non-working@nowhere.com> wrote in message
news:5g5g119l93es7gu9tkg67j31gor6t8u5kg@4ax.com...
> 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.
>
> On Fri, 18 Feb 2005 19:35:20 -0800, "Tessa Ford" <info@webford.co.nz>
> wrote:
>
>>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
>

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?
>-----Original Message-----
>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)
>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
>
>"Tessa Ford" <info@webford.co.nz> wrote in message
news:02d401c51634$09a9ca80$a401280a@phx.gbl...
>> 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
>
>
>.
>

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)
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

"Tessa Ford" <info@webford.co.nz> wrote in message news:065301c51798$63f49b90$a501280a@phx.gbl...
> 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?
>>-----Original Message-----
>>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)
>>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
>>
>>"Tessa Ford" <info@webford.co.nz> wrote in message
> news:02d401c51634$09a9ca80$a401280a@phx.gbl...
>>> 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
>>
>>
>>.
>>

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
>-----Original Message-----
>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)
>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
>
>"Tessa Ford" <info@webford.co.nz> wrote in message
news:065301c51798$63f49b90$a501280a@phx.gbl...
>> 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?
>>>-----Original Message-----
>>>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)
>>>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
>>>
>>>"Tessa Ford" <info@webford.co.nz> wrote in message
>> news:02d401c51634$09a9ca80$a401280a@phx.gbl...
>>>> 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
>>>
>>>
>>>.
>>>
>
>
>.
>

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)
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

"Tessa Ford" <info@webford.co.nz> wrote in message news:0a6a01c5183b$f3293bb0$a501280a@phx.gbl...
> 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
>>-----Original Message-----
>>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)
>>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
>>
>>"Tessa Ford" <info@webford.co.nz> wrote in message
> news:065301c51798$63f49b90$a501280a@phx.gbl...
>>> 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?
>>>>-----Original Message-----
>>>>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)
>>>>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
>>>>
>>>>"Tessa Ford" <info@webford.co.nz> wrote in message
>>> news:02d401c51634$09a9ca80$a401280a@phx.gbl...
>>>>> 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
>>>>
>>>>
>>>>.
>>>>
>>
>>
>>.
>>