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.

"MarcusK" <(E-Mail Removed)> wrote in message
news480F55D-995C-470D-89CF-(E-Mail Removed)...
>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

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/FrontPa...3/Default.aspx
_____________________________________________


"MarcusK" <(E-Mail Removed)> wrote in message news480F55D-995C-470D-89CF-(E-Mail Removed)...
|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

"Andrew Murray" wrote:

> 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.
>
> "MarcusK" <(E-Mail Removed)> wrote in message
> news480F55D-995C-470D-89CF-(E-Mail Removed)...
> >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 Stefan,

no I didn't get ANY error. That's the strange thing.

Marcus

"Stefan B Rusynko" wrote:

> 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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "MarcusK" <(E-Mail Removed)> wrote in message news480F55D-995C-470D-89CF-(E-Mail Removed)...
> |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
>
>
>