How can I investigate if I have Deny permissions set somewhere ?

Thank you for the try, but unfortunately, I still get two rows due to the two different roles and your script does not put them in the same cell. 🙁

Would...

ok....this first one works:

SELECT RTRIM(LTRIM(_MatterInfoVW2_1.lawfirm_code)) AS CLIENT_CD, RTRIM(LTRIM(_MatterInfoVW2_1.LAWFIRM_NAME)) AS CLIENT_NM,

...

Mister Magoo...your solution worked for my simple select statement..thank you !

..BUT, when I add a case statement to the select statement, it stops working...any idea why ?

or any other solutions...

..thank you for the tip..I've done an exhaustive search on the Internet for this type of script, but have not found an example...I would think that this type of script...

No, thats the big mystery...Im not running it from my PC....I have remote desktopped into the SQL Server, build my SSIS package there...run it successfully within SSIS on the server,...

Regarding 2005 components, I have Analysis, Integration, Notification, and workstation....so Im missing the database engine, right ?

It would be crazy to think that all was installed except the database engine,...

GilaMonster,

I went to Add/Remove Progs. and saw that SQL Server 2005 (and 2000) was installed.

Lynn, I have a 2000 standard environment, so that is not the issue.

Maybe I did not...

Steve,

How can I choose, NOT to upgrade ?...I have 2000 as my default instance, then run the 2005 standard install...it SHOULD automatically upgrade my 2000 default environment, should it not...

Sorry if I was unclear, forget about the my 90 compatibility sentence. I know what you mean about changing that, once the upgrade is complete.

No my problem is that my...

Excellent short, to the point, answer my question response Wilfred....thank you

thanks Adam...about SP2...do I need to be concerned with that for users that only have 2005 Client tools (not database) on their machines ?

Thank you...we have the SQL 2005 DVD contents on the network, and I hate to copy the whole thing to a users desktop, only to install Management studio...is there some...

Please see my reply posted at 8:47 pm...that solution works one time, but the next time I use the Access database, I get the same prompt.

To recap the question: how...

Sorry, I dont have that option of 'connection' under File.

BTW, Im using Access 2003