468,512 Members | 1,518 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,512 developers. It's quick & easy.

FrontPage 2003 - Update query Error

MindBender77
234 100+
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
2 2536
jhardman
3,405 Expert 2GB
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
234 100+
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.

Similar topics

4 posts views Thread by Lisa | last post: by
2 posts views Thread by nadmasl | last post: by
7 posts views Thread by Mark Carlyle via AccessMonster.com | last post: by
1 post views Thread by =?Utf-8?B?U2lnMjk4?= | last post: by
5 posts views Thread by abhilashcashok | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.