By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,395 Members | 2,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,395 IT Pros & Developers. It's quick & easy.

FrontPage 2003 - Update query Error

MindBender77
100+
P: 234
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_Data Set [Therapy]='::therapy::'
Where (ID= ::issueid::)

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

Any sugguestion would be appreciated.

Bender
Aug 3 '10 #1
Share this Question
Share on Google+
2 Replies


jhardman
Expert 2.5K+
P: 3,405
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
Aug 6 '10 #2

MindBender77
100+
P: 234
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
Sep 14 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.