Thank you GSquared, I didn't know that.

(If I keep hanging around here, I might someday get the hang of all this foolishness!)

Good questions! It took me a while to make the distinction, but I have yet to define anything other than one user = one login. So I am interested...

Off the top of my head (/guesswork ahead):

I don't think Access can pass arguments to a view, nor can a view take arguments.

Arguments can be passed to a procedure (although...

Thanks very much Matt. That sounds worth a try. And detecting and limiting the damage is all I need.

Better names, thanks chandrachurhghosh.

(Unrelated dumb question, why do you and Phil have a "GO" at the end of your queries?)

I'll buy that if you have a transaction production system, making a clone for query might be a useful practice. But the problem has just moved, not been solved....

"...but what happens when you do need to run a query that's going to take all night to compile its data?"

Then you get your favorite high-priced DBA (if you have...

Geez, when both Jeff and Gail (both of whom I respect) gang up on me, I must be wrong!

But I'm hard to convince, and I see it as a huge...

Thank you so much.

Query Governor (2008!) sounds exactly like what I need.

Frankly, I expected someone to point me to some overlooked system parameter to limit elapsed time, cpu, i/o, etc....

That's the chauvinistic IT department high priest answer!

I don't care about the job title of the author of the problematic query, I just want to limit the impact.

(And please don't...

Thank you for that (I like clean and...

Revealing. Thanks!

It seems inelegant, but create a #temp table (with an agreed upon name) to hold the two argument columns in the calling query, and let the called function/procedure reference that...

For any of the three approaches (Boot Camp, Fusion, Parallels) you need to a copy of XP to install. Boot Camp is free and comes with OSX, but requires a...

I have many (well at least some) that are important.

Consider a table of employees...