I would definately make two separate procedures, but that is just my opinion. If you are going to run them from Access I am pretty sure you can manually set the time until timeout under Tools>Options. I have found that if the code is good Access will not timeout, so if you are having timeout issues it might be a slow connection or some code that needs help, in which case you should post it and let these fine experts here look at it. I don't know how you are calling the procedure from Access, but you should have a command button on a form and do like this:
Private Sub cmdEXECUTE_OnClick()
Dim strSQL as String
strSQL = "EXECUTE Your_Procedure"
DoCmd.RunSQL strSQL
Exit Sub
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.