collecting data from web site form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help. Using FP 2002, I have created a form on my web site and want to
have the results go into a database. When I create an Access db, the server
will not accept the database. When I try to have the results sent to an
email address, I get an error message telling me to us the Server Extensions
Resource Kit. The link for that kit does not work -- probably since I'm
using 2002 and Microsoft has moved on. I really need to be able to get
feedback and make the website interactive but can't let the results go into
cyberspace. I have called the web host and a very helpful TA person worked
with me but could only see that the Access database was somehow flawed. I
need guidance and hope someone can help me. Thanks.
 
What type of server is your site hosted on, and does the server have the FP extensions installed?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
why not save the results to a .csv (it's in the form property options).

If you're getting the error when you try to email you probably don't have
FrontPage extensions in place on that site.
also, FrontPage 2002 extensions are the "newest" and probably "last"
version.

HTH

--
Chris Leeds,
Microsoft MVP-FrontPage

ContentSeed: great tool for web masters,
a fantastic convenience for site owners.
http://contentseed.com/
 
Yes -- Front Page extensions are enabled. The server us Windows based. I
was on a unix server first and changed because unix did not support asp
files. When I attempted to send the results to email, I got an error message
saying that I neede to use the Server Extensions Resource Kit but the url to
Microsoft did not function. If I am not answering your questions, do let me
know. I suppose I could save the results to a csv file but I'm still
confused about how to retrieve the results. I am really desparate to
understand what to do. Help?
 
If your page has a .asp extensions, then you can not use the FP form handler to send email, you
would have to write a custom asp based form handler to do this.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Did you start in your FP web by using File Import and Importing the access .mdb file (allowing FP to put it in the fpdb folder and
create a global.asa file)
- and you must use .asp pages which can only be tested in server based webs (not disc based webs)

Or if you don't know how to create the .mdb create your form in a html page
Then right click the form for Form Properties and select the Database Option
- FP will tell you that you need to edit the form - select yes
- Then select the Create Database Option
(FP will create a db w/ a table for your results based on the form field names)
- when you save the page FP will offer to save it as a .asp page

--




| Yes -- Front Page extensions are enabled. The server us Windows based. I
| was on a unix server first and changed because unix did not support asp
| files. When I attempted to send the results to email, I got an error message
| saying that I neede to use the Server Extensions Resource Kit but the url to
| Microsoft did not function. If I am not answering your questions, do let me
| know. I suppose I could save the results to a csv file but I'm still
| confused about how to retrieve the results. I am really desparate to
| understand what to do. Help?
| --
| nhb -- nc
|
|
| "Chris Leeds, MVP-FrontPage" wrote:
|
| > why not save the results to a .csv (it's in the form property options).
| >
| > If you're getting the error when you try to email you probably don't have
| > FrontPage extensions in place on that site.
| > also, FrontPage 2002 extensions are the "newest" and probably "last"
| > version.
| >
| > HTH
| >
| > --
| > Chris Leeds,
| > Microsoft MVP-FrontPage
| >
| > ContentSeed: great tool for web masters,
| > a fantastic convenience for site owners.
| > http://contentseed.com/
| > --
| > | > > I need help. Using FP 2002, I have created a form on my web site and want
| > to
| > > have the results go into a database. When I create an Access db, the
| > server
| > > will not accept the database. When I try to have the results sent to an
| > > email address, I get an error message telling me to us the Server
| > Extensions
| > > Resource Kit. The link for that kit does not work -- probably since I'm
| > > using 2002 and Microsoft has moved on. I really need to be able to get
| > > feedback and make the website interactive but can't let the results go
| > into
| > > cyberspace. I have called the web host and a very helpful TA person
| > worked
| > > with me but could only see that the Access database was somehow flawed. I
| > > need guidance and hope someone can help me. Thanks.
| > > --
| > > nhb -- nc
| >
| >
| >
 
PS
If using FP to create the DB, it will use the current page name for the DB it creates
- so it is a good idea to first save your html page w/ a simple name for the DB
- say feedback.htm (not the default new_pageX.htm name) for FP to create a DB and DB connection named feedback.mdb

--




| Did you start in your FP web by using File Import and Importing the access .mdb file (allowing FP to put it in the fpdb folder and
| create a global.asa file)
| - and you must use .asp pages which can only be tested in server based webs (not disc based webs)
|
| Or if you don't know how to create the .mdb create your form in a html page
| Then right click the form for Form Properties and select the Database Option
| - FP will tell you that you need to edit the form - select yes
| - Then select the Create Database Option
| (FP will create a db w/ a table for your results based on the form field names)
| - when you save the page FP will offer to save it as a .asp page
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| To find the best Newsgroup for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
| _____________________________________________
|
|
|| Yes -- Front Page extensions are enabled. The server us Windows based. I
|| was on a unix server first and changed because unix did not support asp
|| files. When I attempted to send the results to email, I got an error message
|| saying that I neede to use the Server Extensions Resource Kit but the url to
|| Microsoft did not function. If I am not answering your questions, do let me
|| know. I suppose I could save the results to a csv file but I'm still
|| confused about how to retrieve the results. I am really desparate to
|| understand what to do. Help?
|| --
|| nhb -- nc
||
||
|| "Chris Leeds, MVP-FrontPage" wrote:
||
|| > why not save the results to a .csv (it's in the form property options).
|| >
|| > If you're getting the error when you try to email you probably don't have
|| > FrontPage extensions in place on that site.
|| > also, FrontPage 2002 extensions are the "newest" and probably "last"
|| > version.
|| >
|| > HTH
|| >
|| > --
|| > Chris Leeds,
|| > Microsoft MVP-FrontPage
|| >
|| > ContentSeed: great tool for web masters,
|| > a fantastic convenience for site owners.
|| > http://contentseed.com/
|| > --
|| > || > > I need help. Using FP 2002, I have created a form on my web site and want
|| > to
|| > > have the results go into a database. When I create an Access db, the
|| > server
|| > > will not accept the database. When I try to have the results sent to an
|| > > email address, I get an error message telling me to us the Server
|| > Extensions
|| > > Resource Kit. The link for that kit does not work -- probably since I'm
|| > > using 2002 and Microsoft has moved on. I really need to be able to get
|| > > feedback and make the website interactive but can't let the results go
|| > into
|| > > cyberspace. I have called the web host and a very helpful TA person
|| > worked
|| > > with me but could only see that the Access database was somehow flawed. I
|| > > need guidance and hope someone can help me. Thanks.
|| > > --
|| > > nhb -- nc
|| >
|| >
|| >
|
|
 
Your server must be Windows; it must have the server extensions installed
and it must have ASP installed to work with many of the FP features, such as
the form handler.
 
Thanks to all of you -- hope you'll stay with me until we can solve this
problem. Let me review:
1 -- My server is Windows based and Front Page extensions are installed.
And, asp is also installed according to the technician at Network Solutions
-- the web host.
2 -- I created the form in Front Page and then chose the option in the form
properties to create a database. I verified the connection before publishing
to the internet.
3 -- Prior to adding the form and database, the web published to the
internet without any problems. After I added the form and database,
publishing was interrupted. The form page appeared only in code. After many
attempts, I called the help desk. The technician was very helpful and we
tried several alternatives but he finally said that he thought the database
was flawed and suggested that I create it outside of FP and then try. At
that point, I decided it was better to seek help from this discussion site.

So, at this point, your comments have been focused on verifying that the
server is Windows and that FP extensions are enabled. And, one more thing --
I removed the database to see if the form would publish. It publishes fine
now but there is no way to use it because it needs the database and/or some
means or retrieving the data. It is a simple website -- I'm actually using
it to update my skills before doing a more complex one. The url is
www.lukesinst.com if you would like to look at it and offer suggestions.

Many thanks for your suggestions. I hope you will stay with me until the
problem is resolved.
 
Have you open the live/remote site in FP and then verified the database connection?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Yes. I went to Tools/Web Settings/Database tab and verified the connection
before publishing. Any other ideas?
 
one more bit of info. When I was talking to the technician at Network
Solutions and explained that the Access database was in a folder labeled
"fpdb" he wanted me to change the name of the folder to "db". I did but that
did not make any difference. Does it matter where the access database is
stored in the front page website file?

Also -- I still have the question about how the data is retrieved. Since I
have not seen it work, I am unclear about how the data gets into the database
from the internet. How do I download it?
 
You need to do this after you have published it to the live/remote site in FP.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Do not change the folder name, and you then remove the permissions from the folder and the database.
The tech you spoke with doesn't have a clue how the FP extensions work with the FP database
components.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
OK -- Thx Thomas. I think you are saying that I should not verify the
connection until after I have published. I will try that. And, I know
you're right about the tech being incorrect in telling me to change the
folder name. Thanks. I will try to reset the form and get back to you. I
appreciate your staying with me on this.
 
Back
Top