ASP Query forms not working

[jonathan]

I have just posted a new site to my intranet and have input forms - all are
working fine! The problem comes when tyring to run a query. I have an ASP
form with no query that works fine, however I have a couple forms for users
to query against the database, when I run the query in a browser I get a 405
rescource unavailable error..........

What am I missing?

TIA

Jonathan

 

[Skydolphin]

Can you give a little better explanation of your problem. I might be able to help but I am not following what exactly is happening

Rhond

 

[jonathan]

Thanks Rhonda

I have solved this problem now (I forgot to re-run the database reports
wizard), but now I have found another more frustrating problem, I can add
records, delete records but not edit records I get the following message on
screen

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
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.

Can you help with this one?


J

Can you give a little better explanation of your problem. I might be able

to help but I am not following what exactly is happening.

 

[Tom Miller]

Thanks Rhonda

I have solved this problem now (I forgot to re-run the database reports
wizard), but now I have found another more frustrating problem, I can add
records, delete records but not edit records I get the following message on
screen

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
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.

What happens if you set a default (in the form) for all the fields in the
database? So that there is never a null field?