Add record to access database - record not added

[Guest]

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?

 

[Guest]

Please try:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.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

 

[Guest]

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.

 

[Kathleen Anderson [MVP - FrontPage]]

Trevor:
What version of FrontPage are you using?

 

[Guest]

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

 

[Guest]

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!