>>Well, you actually will hit the USE command twice. First one will trigger the error, then the RETRY will run the same line of code, which is a USE, so it is the same thing that I was doing.
>
>Craig,
>
>One big differencwe, with your approach you have take care of every USE command, with the error handler doing a retry you can forget about that error when you write you other code.
Yes, true...but either way, it comes down to trying open the table, getting an error, then opening it....I don't think one way is any better than the other.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer