Personalization, Customization and Productivity Tools

[CV]

I currently have an Excel workbook that has 3 different ODBC linked worksheets to MAS. Upon refresh - I have to login into MAS 3x's.

Is there any way to login once for all 3 worksheets without embedding the login/PW into the ODBC setup or the worksheet code?

[connex]

Nope. You could lock down the ODBC credentials in VBA code in the Excel workbook with a password.  User's could buy software to defeat it though. You could also use a pass through query in MS Access and force your users to acquire Access in addition to breaking the VBA password.

Why not just use MAS ODBC security and create MAS credentials with only the priviledges needed for the workbook and embed those. 

[thebottomline]

Dan,

Not everyone has devious users as you describe.

CV, Dan has describe some very good ways to accomplish your goals but you might need an advanced degree in rocketry to figure them out.  I personally like the pass through query option.  I use it quite a lot and have had good results with it.

If you send me an e-mail, I will give you a simple "hack" that will work very nicely for you.

[RachelleAnderson]

I've tried connex's MS Access pass through query as well and it works great for me. But if it doesn't solve the issue for you, you should definitely take advantage of thebottomline's offer to make things easier for you.