470,647 Members | 1,268 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

What should I do if one of my update fails?

I'm setting up a site that prompts a user for information
about people and stores the results in a Access database.
This database is then used to create accounts on the
network.

To store the user data I need to run three separate INSERT
queries into an Access 2000 database.

What I'd like to know is, should one of these updates
fail. What should I do? Especially if its the second or
third update! At the moment all I'm doing is watching to
see if there is an error in each update function. If
there is one, then it abandons the whole thing and
redirects to an error page.

Should I be trying to backout of any previous updates, or
trying the broken function... or something else? What is
the correct course of action in such circumstances?

TIA,

Colin
Jul 19 '05 #1
2 1421
use transactions - ADO supports them with ease. if one fails, the rest
will be rolled back, and they're also well documented.

________________________________________
Atrax. MVP, IIS
http://rtfm.atrax.co.uk/

newsflash : Atrax.Richedit 1.0 now released.
http://rtfm.atrax.co.uk/infinitemonk...trax.RichEdit/

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #2
Atrax <at***@dontspamatrax.co.uk> wrote in message news:<e3**************@TK2MSFTNGP12.phx.gbl>...
use transactions - ADO supports them with ease. if one fails, the rest
will be rolled back, and they're also well documented.


ADO can do that! Excellent, I wasn't aware of this feature. I'll
crack open my ASP book tomorrow and look it up, I'm sure it has a
section on ADO.

Thanks very much!

Colin
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Fraser Hanson | last post: by
2 posts views Thread by Richard | last post: by
5 posts views Thread by PAUL | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.