Re: Secure OleDb Connection to a Microsoft Excel Workbook

Larry,

I realise that Excel isn't a database, but I am unable to use Microsoft
Access, SQL or the like as the users in the organisation do not have
access to them.

The only software standard on the machines is Microsoft Word, Excel and
PowerPoint. As such, I have needed to build the solution around the
software available. Microsoft Excel meets the requirement for the
keeping of the basic tables and the people who need to modify the data
understand how to work with that program.

The only problem is currently it is set-up with-out protection so those
that shouldn't have access do, which causes a number of frustrations.

If you have any further ideas on how to secure the workbooks please let
me know.

Yours sincerely,

William Foster

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Benefits of upgrading to Excel2003
    ... You probably don't have access to Excel 2002 and excel 2003 so I've ... Key new features in Microsoft Excel ... Web queries to Extensible Markup Language files. ... If you are not using the specific language version of Microsoft Office ...
    (microsoft.public.excel.misc)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... "Microsoft also released a Cube add-in for Excel, ... >I have watched webcast after webcast about SQL Server 2005 Business ...
    (microsoft.public.sqlserver.olap)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... >>I have watched webcast after webcast about SQL Server 2005 Business ... >> touches on their new clients, as well as many other Microsoft Partners ... >> Then there is Excel. ... >> to find that it still costs more to buy the client tools which have ...
    (microsoft.public.sqlserver.olap)
  • Re: Excel 2004 crashes with Right Mouse Button click in OS X 10.4.8
    ... Is your RAM Apple branded, ... Microsoft Office applications? ... I launch Microsoft Excel. ... USB Device: Apple Internal Keyboard / Trackpad, Apple Computer, Up to ...
    (microsoft.public.mac.office.excel)
  • Re: why>?
    ... also; back in the 90s; it might have been a good idea to use Excel. ... Adobe Acrobat and DB2 mainframes-- it is obvious that they need to wake ... Microsoft dug their own hole with regard to antitrust. ...
    (microsoft.public.excel)