May 22, 2024, 06:28:31 AM


IonicWind Snippit Manager 2.xx Released!  Install it on a memory stick and take it with you!  With or without IWBasic!

Access errors

Started by billhsln, May 29, 2018, 11:01:44 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


I have a program I have been working on and I noticed that when I try to UPDATE a record that does not exist, ACCESS does not come back with an error.  I need it to error if there is no match.  I ended up having to change the code to do an INSERT, which worked.  Just don't understand why the UPDATE did not give me an error when the record did not exist.

When all else fails, get a bigger hammer.