It might have something to do with this
appAccess.Run "openjobdetailsform", GetJobID(strJobNumber)
You may be tying up the application with whatever that is; i.e. code needs to wait. What is that?
FYI - it's common courtesy to post links to all forums where you have posted your problem. It allows us to review any answers you got there so that we're not making the same suggestions. It's good that you declared you have posted elsewhere, so that's a start!
EDIT - also thinking that if setting the Visible property of the open database doesn't work, try using the SetFocus API. I don't have an example of it, but you should be able to find code for it.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.