No clue... Are you sure that you didn't spill coffee in that cup holder??

God I'd like to see a picture of that .

"A general principal about Access is that is allows really poor "developers" to create really poor apps that actually work anyway, most of the time."

I'm still rolling on the floor...

I'm the police forum, now back to work Erik .

Can you try to put that image (C:\Documents and Settings\mexware3\My Documents\rserror.JPG) on a webserver so that we can have a shot to guess????

the other rg are all here... they are just not posting as much as me. As for Frank, he's far from replaced.

To complete >> it can be physically stord on disk if you index the column. But for 99% of the calculated columns, they are calculated on the fly when...

I usually go mid way in a new task. I try to automate it as much as possible without losing to much time... but when I get it asked...

Please do not cross-post.

Check this thread out :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202

EXEC sp_MSForeachDB 'if ''?'' in (''master'',''model'',''msdb'',''pubs'') begin Select ''?'' as ExecutedIn end'

Check this thread out :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202

That would be a good way to dumb you guys up... I learnt here by reading answers. Now if you take out the 100 answers/week, that makes that many less...

That was a great point to add... if someone doesn't know that #temp (local temp) are visible only through that connection... but that's another story.

... exactly why I respecified TEMPDB..SysObjects .

Still don't know why.