what's a SAFE way to let my boss connect to the Cache database (VIEW ONLY)
The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc"
is there a SAFE way I can give him access to our database using an intelligent visual user interface.
I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal.
I also need to make it READONLY, again for obvious reasons.
and of course hide all the % classes
I've played with Beaver, but can't see how I can give him restrictions,
Anyone got any good ideas how I can give the boss what he wants. ?
Kevin