UPDATE not updating

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hello,

I have 2 files that work on an Access DB. One inserts
rows into it, and the other updates a Yes/No field,
setting it to true. This setup used to work, but I've
updated the first file and the DB. Now, the UPDATE
doesn't change the field to True, and returns no error.
If I go back to the old first file, it works fine. Any
ideas what could cause this?

Thanks
 
Phil,

It will be rather difficult to diagnose the problem or offer a solution
without some additional information from you.
I have 2 files that work on an Access DB. One inserts
rows into it, and the other updates a Yes/No field,
setting it to true. This setup used to work, but I've
updated the first file and the DB.
Click to expand...

What do you mean "2 files that work on an Access DB" and "first file"?
Are these programs which are not a part of Access? What kind of update did
you make?

Since you report that there is no error on your UPDATE, is it possible that
one of these files had some sort of If ... EndIf statement added to it? For
example,

If [Something] = [SomeOtherThing] then
'Update code here
End If

and for whatever reason, the IF is never true?

If this is not the answer, please post back with more detail, including your
code.
 
Phil

Can you "manually" update a row's True/False field?

Are you certain the SetWarnings property is still True?

I don't understand "files" that "update" and "append" into Access
databases -- could you explain more?

Good luck

Jeff Boyce
<Access MVP>
 
Ok...here's a more detailed explanation.
I have 2 ASP files that work on an Access DB - Update.asp
and ThankYou.asp. Update.asp inserts rows into the DB,
and ThankYou.asp updates a Yes/No field, setting it to
true. This setup used to work, but I've updated
Update.asp and the DB. Now, the UPDATE statement in
ThankYou.asp doesn't change the field to True, and returns
no error. If I go back to the old Update.asp, it works
fine.

The updates I've made are:
In the DB, I added a text column.
In Update.asp, I changed it from being able to append the
DB upon submission of a form to functioning as
an "autosave" for the form (it's called from a Java
applet).

ThankYou.asp has not changed, and the UPDATE statement is
not enclosed in an If...Then statement.

Thanks again for your help.
 
strSQL = "UPDATE OrderDetails SET Uploaded=True,
ETADate=#" & cdate(strDateComplete) & "# WHERE
OrderNumber=" & intJobOrderNumber
response.write strSQL & "<BR>"
objcon.Execute strSQL

But, like I said, this code (from ThankYou.asp) DID work
until I changed the other file (Update.asp).
 
Back
Top