Or could it simply be the special characters in the instance name that should be quoted?

LOL... I know what you mean... probably a really bad habit but the only time I normally use the ANSI "Join" statements is when an outer join is present. 

Yeowch!  When you jab someone in the eye with a sharp stick, you should at least tell them why

Guess it does help to click on the Author's name and see previous posts... especially if you remember something similar.  Thanks for identifying the dead horse, Phil.

Sam, I think step 1 would be to post you question in the Access forum.  Lots of us just don't go anywhere near Access and, as you know, the solutions...

Heh... I try to write "Fine" solutions because I've had "Mo-den-enough" with the ones that aren't   Thanks for the great compliment, Steve!

Heh... although they both have the same execution plan, I'm not sure why you wrote it as a Cross-Join that works like an Inner Join... why not just write it...

Yep...

Doh!   My bad... made an assumption  Thanks for the feedback.

LOL... I just knew I liked you for more than the code you write   I'm getting soft in my old age and...

Thanks, Vamshi... I really appreciate your feedback.

That returns the max data length for those items you want to update... not all items.  That not-with-standing, it looks to me like you have well under the 8000 characters...

Not really... if you create a # temp table (non-global) in a proc, that temp table will be available in any proc below that because it's the same session (although it's...

Hari... are you calling the function using SQL that's embedded in the GUI code?  If so, Koji is absolutely correct... the code must add the outer quotes as part of...

Heh... you're right, David.   But it was easy to find... just clicked on the author's name and looked at the previous posts for...