A confirmation form appears, but no data is written to the table

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

Guest

I created a survey form and used the create database wizard in the forms
properties options dialog. The database has been created. When I use the form
a confirmation page is displayed, but no data is wtitten to the database. I
checked the KB and found KB314440, but it didn't help. The table was created
with the wizard and has no primary keys. The wizard created an autonumber
field. All fields of the form are not required and the table has no primary
key fields. Removing the on error line as described in KB314440 didn't give
any insight either. Does anybody has an idea?

Marcus
 
The 'autonumber' field (the Record Number) actually is the primary key
field. If you open the database in Access, and go to the table design view
you will see this.

Just wanted to point that out, but unfortunately I can't help with a
solution to the problem.
 
When you removed that line did you get an error:
Cannot update the database.
Post a URL to the Form online or list your DB field names

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I created a survey form and used the create database wizard in the forms
| properties options dialog. The database has been created. When I use the form
| a confirmation page is displayed, but no data is wtitten to the database. I
| checked the KB and found KB314440, but it didn't help. The table was created
| with the wizard and has no primary keys. The wizard created an autonumber
| field. All fields of the form are not required and the table has no primary
| key fields. Removing the on error line as described in KB314440 didn't give
| any insight either. Does anybody has an idea?
|
| Marcus
 
Hi Andrew,

the wizard that creates the table doesn't add a primary key to the table.
The autonumber ID field is a field of the table, but none of the fields has a
primary key added to it. I added the primary key to the table by hand to see
if it would make a difference, but it didn't.

Marcus
 
Back
Top