I have built a web form that writes to a Access database
using the frontpage 2002 database connection wizard. Now I
would like to add a field that writes to the database.

I have created a field called "group" in the Access
database, how do I add the entry on my form so that it
writes the result without starting over?

It would have been better to have added the field to the form first, and
then let the DRW add the field to the database.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, 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

"Curtis" <(E-Mail Removed)> wrote in message
news:1170301c383b5$64ad63f0$(E-Mail Removed)...
> I have built a web form that writes to a Access database
> using the frontpage 2002 database connection wizard. Now I
> would like to add a field that writes to the database.
>
> I have created a field called "group" in the Access
> database, how do I add the entry on my form so that it
> writes the result without starting over?
>

I realize that. However the form has been in use for some
time and now the department that collects the data needs
this new entry. The form is huge so starting over is not
an option.

Anyone have a constructive answer?


>-----Original Message-----
>It would have been better to have added the field to the
form first, and
>then let the DRW add the field to the database.
>
>--
>
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, Forums, 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
>
>"Curtis" <(E-Mail Removed)> wrote in message
>news:1170301c383b5$64ad63f0$(E-Mail Removed)...
>> I have built a web form that writes to a Access database
>> using the frontpage 2002 database connection wizard.
Now I
>> would like to add a field that writes to the database.
>>
>> I have created a field called "group" in the Access
>> database, how do I add the entry on my form so that it
>> writes the result without starting over?
>>
>
>
>.
>

maybe I misunderstood your answer...

If I delete the entry in the database, then add the field
named 'group' to the form, will it automatically write
the field to the database??? That dont sound right...also
when I Publish this page again, wont it overwrite all the
entries that are already entered in the database?


>-----Original Message-----
>It would have been better to have added the field to the
form first, and
>then let the DRW add the field to the database.
>
>--
>
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, Forums, 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
>
>"Curtis" <(E-Mail Removed)> wrote in message
>news:1170301c383b5$64ad63f0$(E-Mail Removed)...
>> I have built a web form that writes to a Access database
>> using the frontpage 2002 database connection wizard.
Now I
>> would like to add a field that writes to the database.
>>
>> I have created a field called "group" in the Access
>> database, how do I add the entry on my form so that it
>> writes the result without starting over?
>>
>
>
>.
>