Reply to rja.carnegie's comment: (I mistakenly assumed "replying" to an existing message would link it to that message.)

What stunned me was that it was stated exactly like that. (From...

Perhaps it is a question of need, urgency, and scope.

Consider that many information needs are high in urgency and narrow in scope.

Should these needs be unmet because IT...

I think communication is key. Unfortunately there is often a huge disconnect between IT and business end users.

IT is important and has a strong position to play in any...

The problem with "perfection" is that it is contextual. Code that is "perfect" now will be buggy when conditions change.

The idea that someone can "prove" with mathematical precision that...

Excellent topic!!

I've been on both sides of the fence over the past (too many) years.

On one side (A) as a mainframe programmer in the USAF, software developer, and consultant, and...

Although this makes sense from a $$ standpoint it sounds like a horrible choice from a security standpoint.

35,000 servers, all in one building, makes one hell of a target.

Since they...

I came across the following at http://technet.microsoft.com/en-us/library/cc966377.aspx.

While researching how trying to find out exactly what would happen when an Access query operating against tables that are located on...

I think perceived perfomance level plateued several years ago and has begun to fall.

Perhaps it is a bit like going from a pool table to a snooker table. Larger...

Ah. Got it. Thanks Matt.

Am I correct in assuming that forcing it to be pass-thru is only useful if all the tables being joined reside on the...

Hmm. I just popped into Access 2003 opened an existing query in SQL design mode, right clicked and selected Properties. However, I don't see that anything that lists...

Agreed. These products each have their time and place for use.

I for one wouldn't want to try to run ERP for a manufacturing firm on Access...

Blandry;

I think your honing in on my complaint.

It takes our IT department days, weeks, and months to meet...

Thanks for the info Richard.

You are correct, I am not the DBA, I am the lead system analyst for our division.

Perhaps the issue is the difference between static...

Chris;

Maybe your getting to what I need to know. And you have given me a chance to show my ignorance.

...

I've relied heavily on ODBC, combined with MS Access for the past 10 years. At my last company virtually all the reporting out of the Syteline ERP system was...