Never mind, I think. I just discovered this:

For files that have the Excel 2007 or later format, the package requires the OLE DB provider for the Microsoft Office 12.0 Access...

I guess I am hearing about MS Charting Controls (apparently similar to the controls available within Reporting Services) and am wondering "Why not just use the Charting Controls with .NET...

Thanks to all who responded. This suggestion, from RBarry, addresses all of our concerns and performs well upon testing for us:

The first is to have the application use a trusted...

Thanks for your response.

As per your comments, "2. Any user who has access ..." - Agreed. However, if users don't access SQL Server directly, but only via logins/accounts known to...

Never mind - I remembered enough of the code to be able to recreate it and test it.

One of the author's concerns was that the corruption problems didn't occur when SQL Server was on a physical server, but that the corruption consistently occurred when SQL Server was...

I am not opposed to using CLR or managed code, although I haven't tried doing so yet. I will investigate what you have referred me to. Thanks!

Thanks for the responses. Interesting that you mention the logon trigger idea, b/c since I wrote my original post, I had been tossing around an idea similar to that as...

Using a single account for the application, how then does SQL Server distinguish the amount of access to grant the user? This is assuming that some users use the application...

SQL Server 2005, SP2, no additional service packs or cumulative updates after SP2.

These posts have been very interesting to read.

For our in-house development, Visual FoxPro has been our primary development tool, although Microsoft's actions have pushed us to move toward and become...

I'm working on this in conjunction with our network administrator, as handling Windows security is fairly new to me.

I don't know what you mean by the "BP" in your question...

Thanks, that's what I needed to know!

Best wishes,

Randy

Greetings,

This has been an interesting read for me, as I am a newcomer to SQL Server (1 year), having been an application developer for database-centric applications with my company since...

Thanks very much to those who responded.

Bitbucket, from the link you suggested, it started to become apparent that it was database roles, not application roles, that I was needing. ...