Database Connection problem

[Raymondo]

I am really confused. my databases have been working fine for a couple of
years but suddenly my forms do not submit to the database. (well one does
but others do not) I spoke to my ISP host and they said that maybe my
software needing upgrading so have upgraded to Office 2007 and Expression
2007 have saved the pages and database and re published them all to no avail.


Have tried copying the one form that does submit properly but the copied
version fails to submit! i have tried a brand new form and that fails. Have
tried a new form and creating a new database but this fails. - none of these
give any errors, they go to the confirmation page with the correct
information but it is not included on the database!

This may be unrelated but The DBRW also has a problem it brings up the
current details from the database but the update facility gives an error:
Database Results Wizard Error
Description: Operation must use an updateable query.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

I have checked the default values for all number fields and have bracketed
any reserved words - [timestamp] and have re entered the s-columnames and
s-columntypes

Sorry long question but I have tried all ways to resolve the issue. Can
anyone help me??

 

[Thomas A. Rowe]

Ask your host to run a server health check on the extensions to reset/correct the permissions.
Upgrading to Office 2007 or Expression will not solve this issue.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Raymondo]

Thank you - I will do that and let you know the result. I did mean to say
that i had also verified the connections and that the database is in the FPDB
folder.

Ask your host to run a server health check on the extensions to reset/correct the permissions.
Upgrading to Office 2007 or Expression will not solve this issue.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

I am really confused. my databases have been working fine for a couple of
years but suddenly my forms do not submit to the database. (well one does
but others do not) I spoke to my ISP host and they said that maybe my
software needing upgrading so have upgraded to Office 2007 and Expression
2007 have saved the pages and database and re published them all to no avail.


Have tried copying the one form that does submit properly but the copied
version fails to submit! i have tried a brand new form and that fails. Have
tried a new form and creating a new database but this fails. - none of these
give any errors, they go to the confirmation page with the correct
information but it is not included on the database!

This may be unrelated but The DBRW also has a problem it brings up the
current details from the database but the update facility gives an error:
Database Results Wizard Error
Description: Operation must use an updateable query.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

I have checked the default values for all number fields and have bracketed
any reserved words - [timestamp] and have re entered the s-columnames and
s-columntypes

Sorry long question but I have tried all ways to resolve the issue. Can
anyone help me??

 

[IdaSpode]

Just for giggles, try changing any number fields in the database to
text fields.

I just went through much the same thing. Several forms I have on a
site functioned perfectly last year, now suddenly as I go to update
the site for this year, some forms no-workie.

This particular site and the forms on it are only used for a couple of
months each year during a registration process for a two day
motorcycle event.

As I'm not doing any mathematical computation with the data submitted,
I changed the number fields to text fields, all works fine now.

Since they work, I will probably leave them as they are, but it dawned
on me later that the error msg about "setting default values" probably
meant setting them in the database, not on the form. I had no defaults
set for the number fields.

Why this change happened baffles me...

DJ

 

[Raymondo]

Hi DJ, Ok I will try but the only true number field is the automatic ID
field. Did you change this as well?

Raymondo

 

[IdaSpode]

Hi DJ, Ok I will try but the only true number field is the automatic ID
field. Did you change this as well?

No, that is generated when the record is created, not from data sent
to the DB by the form.

Maybe my problem is/was different from yours.

DJ
------

 

[Raymondo]

Thanks DJ - that's what I thought.

Mind you the problem has been sorted with my hosting company finally
agreeing that the write permissions had been removed from the mdb files - I
bludgeoned them with Thomas's reply above and now they are back in place it's
all ok!