I've used the FRP DIW to create a submission page to add a record to a table
in an access database. The page seems to work, in that it returns the
confirmation page after adding the record. When inspecting the table in the
DB the 'added' record is not there.

I'm new to FP and web development and am struggling to resolve this. How can
I find the cause of the problem?
--
Trevor

Please try:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tip...ow.aspx?tip=35

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming


"Trevor" wrote:

> I've used the FRP DIW to create a submission page to add a record to a table
> in an access database. The page seems to work, in that it returns the
> confirmation page after adding the record. When inspecting the table in the
> DB the 'added' record is not there.
>
> I'm new to FP and web development and am struggling to resolve this. How can
> I find the cause of the problem?
> --
> Trevor

Jim, thanks for your tip which I implemented. No errors are reported though,
so I'm still stuck.

Any suggestions onmoving forward? The access database table is a simple two
field table one of which is defined as autonumber. The frontpage submission
form was created using the wizard and I then removed the cell for the
autonumber field. I'm assuming that access will add the data for this field
automatically.

When using the form via IE it accepts the input and moved onto the
confirmation display, but no record appears in the DB table.
--
Trevor


"Jim Buyens" wrote:

> Please try:
>
> Diagnosing Errors Saving a Form to a Database
> http://www.interlacken.com/winnt/tip...ow.aspx?tip=35
>
> Jim Buyens
> Microsoft MVP
> http://www.interlacken.com
> Author of:
> o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
> Now!
> o--> Microsoft Office FrontPage 2003 Inside Out
> o--> Microsoft Windows SharePoint Services Inside Out
> o--> Faster Smarter Beginning Programming
>
>
> "Trevor" wrote:
>
> > I've used the FRP DIW to create a submission page to add a record to a table
> > in an access database. The page seems to work, in that it returns the
> > confirmation page after adding the record. When inspecting the table in the
> > DB the 'added' record is not there.
> >
> > I'm new to FP and web development and am struggling to resolve this. How can
> > I find the cause of the problem?
> > --
> > Trevor

Trevor:
What version of FrontPage are you using?

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


"Trevor" <(E-Mail Removed)> wrote in message
news:47E88C2C-79C0-4B20-825B-(E-Mail Removed)...
> Jim, thanks for your tip which I implemented. No errors are reported
> though,
> so I'm still stuck.
>
> Any suggestions onmoving forward? The access database table is a simple
> two
> field table one of which is defined as autonumber. The frontpage
> submission
> form was created using the wizard and I then removed the cell for the
> autonumber field. I'm assuming that access will add the data for this
> field
> automatically.
>
> When using the form via IE it accepts the input and moved onto the
> confirmation display, but no record appears in the DB table.
> --
> Trevor
>
>
> "Jim Buyens" wrote:
>
>> Please try:
>>
>> Diagnosing Errors Saving a Form to a Database
>> http://www.interlacken.com/winnt/tip...ow.aspx?tip=35
>>
>> Jim Buyens
>> Microsoft MVP
>> http://www.interlacken.com
>> Author of:
>> o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web
>> Site
>> Now!
>> o--> Microsoft Office FrontPage 2003 Inside Out
>> o--> Microsoft Windows SharePoint Services Inside Out
>> o--> Faster Smarter Beginning Programming
>>
>>
>> "Trevor" wrote:
>>
>> > I've used the FRP DIW to create a submission page to add a record to a
>> > table
>> > in an access database. The page seems to work, in that it returns the
>> > confirmation page after adding the record. When inspecting the table
>> > in the
>> > DB the 'added' record is not there.
>> >
>> > I'm new to FP and web development and am struggling to resolve this.
>> > How can
>> > I find the cause of the problem?
>> > --
>> > Trevor

Did you just delete the autonumbered field from the form, or did you also
delete it from Form Properties, Options, Saved Fields?

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming


"Trevor" wrote:

> Jim, thanks for your tip which I implemented. No errors are reported though,
> so I'm still stuck.
>
> Any suggestions onmoving forward? The access database table is a simple two
> field table one of which is defined as autonumber. The frontpage submission
> form was created using the wizard and I then removed the cell for the
> autonumber field. I'm assuming that access will add the data for this field
> automatically.
>
> When using the form via IE it accepts the input and moved onto the
> confirmation display, but no record appears in the DB table.
> --
> Trevor
>
>
> "Jim Buyens" wrote:
>
> > Please try:
> >
> > Diagnosing Errors Saving a Form to a Database
> > http://www.interlacken.com/winnt/tip...ow.aspx?tip=35
> >
> > Jim Buyens
> > Microsoft MVP
> > http://www.interlacken.com
> > Author of:
> > o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
> > Now!
> > o--> Microsoft Office FrontPage 2003 Inside Out
> > o--> Microsoft Windows SharePoint Services Inside Out
> > o--> Faster Smarter Beginning Programming
> >
> >
> > "Trevor" wrote:
> >
> > > I've used the FRP DIW to create a submission page to add a record to a table
> > > in an access database. The page seems to work, in that it returns the
> > > confirmation page after adding the record. When inspecting the table in the
> > > DB the 'added' record is not there.
> > >
> > > I'm new to FP and web development and am struggling to resolve this. How can
> > > I find the cause of the problem?
> > > --
> > > Trevor

Jim

I regenerated the page to fully exclude the autonumber field, this didn't
resolve the problem.

Your suggestion was very helpful though. Investigating the form properties,
options tab, then additional fields tab; I discovered that four extra fields
where being posted (ip addr etc), I removed those four fields and hey presto,
it works! Again, thanks for pointing me in the right direction!
--
Trevor


"Jim Buyens" wrote:

> Did you just delete the autonumbered field from the form, or did you also
> delete it from Form Properties, Options, Saved Fields?
>
> Jim Buyens
> Microsoft MVP
> http://www.interlacken.com
> Author of:
> o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
> Now!
> o--> Microsoft Office FrontPage 2003 Inside Out
> o--> Microsoft Windows SharePoint Services Inside Out
> o--> Faster Smarter Beginning Programming
>
>
> "Trevor" wrote:
>
> > Jim, thanks for your tip which I implemented. No errors are reported though,
> > so I'm still stuck.
> >
> > Any suggestions onmoving forward? The access database table is a simple two
> > field table one of which is defined as autonumber. The frontpage submission
> > form was created using the wizard and I then removed the cell for the
> > autonumber field. I'm assuming that access will add the data for this field
> > automatically.
> >
> > When using the form via IE it accepts the input and moved onto the
> > confirmation display, but no record appears in the DB table.
> > --
> > Trevor
> >
> >
> > "Jim Buyens" wrote:
> >
> > > Please try:
> > >
> > > Diagnosing Errors Saving a Form to a Database
> > > http://www.interlacken.com/winnt/tip...ow.aspx?tip=35
> > >
> > > Jim Buyens
> > > Microsoft MVP
> > > http://www.interlacken.com
> > > Author of:
> > > o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
> > > Now!
> > > o--> Microsoft Office FrontPage 2003 Inside Out
> > > o--> Microsoft Windows SharePoint Services Inside Out
> > > o--> Faster Smarter Beginning Programming
> > >
> > >
> > > "Trevor" wrote:
> > >
> > > > I've used the FRP DIW to create a submission page to add a record to a table
> > > > in an access database. The page seems to work, in that it returns the
> > > > confirmation page after adding the record. When inspecting the table in the
> > > > DB the 'added' record is not there.
> > > >
> > > > I'm new to FP and web development and am struggling to resolve this. How can
> > > > I find the cause of the problem?
> > > > --
> > > > Trevor