Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Anyone Seen a Write Race Condition?

Anyone Seen a Write Race Condition?

Anyone Seen a Write Race Condition?

I have some old code that I am looking at...

It concatenates a SQL statement to Insert into "TblB" which is executed with DoCmd.RunSQL.

Next it Updates "TblA" that is left joined to "TblB" and has a where clause that uses IS Null on one of the joined fields - a classic update on missing values. It was also executed with DoCmd.RunSQL

What happened though is all values were identified as missing where none of them should have been missing based on the data result.

Has anyone seen anything like this? Any absolute workarounds? I added a Doevents between the two but somehow I have doubts and this may not be the only case it can happen.

Other details:

This happened in a frontend with both tables local. Yes it is using "temp" tables in the frontend file.
Windows 7
Access 2013
Big corporate environment
Security set to paranoid (If you can think of it, it is probably done here)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close