FrontPage 2003 - Update query Error

[MindBender77]

Hello again, All...
Admin's, I wasn't sure where to post this, please move if in wrong forum.

I'm using FrontPage 2003 to post form data to a second form to be used in an update query. The query then updates a record in an Access database.

I get this when the page is displayed:
Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.

I replaced the update query with a simple select query and the selected record is displayed without error. Here is the query's syntax: It seems the AutoNumber field is the problem but, I'm not sure why.

Update tbl_Main_Pt_Dat a Set [Therapy]='::therapy::'
Where (ID= ::issueid::)

This update query works if I enter (ID=66)..

Any sugguestion would be appreciated.

Bender

[jhardman]

I'm not too familiar with front page syntax, but I assume ::therapy:: and ::issueid:: are variables, so that when the page runs it replaces these with other text, right?

If so, try to print out the FINAL VERSION of the update query to see what is actually being sent to the db.

Jared

[MindBender77]

Thanks for the reply Jared and no, ::therapy and ::issueid:: are textboxes on a form. I found the problem to be permission changes and had to download different versions of 3 frontpage files to allow an update query to run. Odd issue but, its been resolved.

Bender