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

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.
==============================================

"Nancy" <(E-Mail Removed)> wrote in message
news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
>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

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/
--
"Nancy" <(E-Mail Removed)> wrote in message
news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
> 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

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/
> --
> "Nancy" <(E-Mail Removed)> wrote in message
> news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
> > 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
>
>
>

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.
==============================================

"Nancy" <(E-Mail Removed)> wrote in message
news:87CD80F5-5CBA-4C83-98D9-(E-Mail Removed)...
> 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/
>> --
>> "Nancy" <(E-Mail Removed)> wrote in message
>> news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
>> > 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
>>
>>
>>

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
_____________________________________________


"Nancy" <(E-Mail Removed)> wrote in message news:87CD80F5-5CBA-4C83-98D9-(E-Mail Removed)...
| 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/
| > --
| > "Nancy" <(E-Mail Removed)> wrote in message
| > news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
| > > 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

--

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


"Stefan B Rusynko" <(E-Mail Removed)> wrote in message news:%23EbfJ$(E-Mail Removed)...
| 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
| _____________________________________________
|
|
| "Nancy" <(E-Mail Removed)> wrote in message news:87CD80F5-5CBA-4C83-98D9-(E-Mail Removed)...
|| 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/
|| > --
|| > "Nancy" <(E-Mail Removed)> wrote in message
|| > news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
|| > > 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.

"Nancy" <(E-Mail Removed)> wrote in message
news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
>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

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.
--
nhb -- nc


"Andrew Murray" wrote:

> 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.
>
> "Nancy" <(E-Mail Removed)> wrote in message
> news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
> >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
>
>
>

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.
==============================================

"Nancy" <(E-Mail Removed)> wrote in message
news:05F1CDFD-04A9-42FB-BB15-(E-Mail Removed)...
> 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.
> --
> nhb -- nc
>
>
> "Andrew Murray" wrote:
>
>> 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.
>>
>> "Nancy" <(E-Mail Removed)> wrote in message
>> news:7E4B8953-5467-4246-B619-(E-Mail Removed)...
>> >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
>>
>>
>>