General information
Category:
COM/DCOM and OLE Automation
Environment versions
Network:
Windows 2008 Server
Hi,
Using Excel 2007 Automation from VFP I have connected a SQL database and created a Pivot Table from a huge dataset. The connection string is supplied in the automation program. Using SQL authentication, the connection string must contain user and password. It is quite important to hide these credentials from the users that will use the program for reporting. But in the Data-tab in Excel 2007 there is Connections->Properties->Definition->ConnectionString displaying the connection in clear text. I know I can add a password to the worksheet using .ActiveWorkbook.Protect(.T.,.T.), but the connectionstring will only be disabled. Is there a way to disable the menuitem?
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only