Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Query security
Is there a way to have the functionality of Microsoft Query and yet prevent a
user from creating a new database connection & query that would allow access to records for editing? There must be a way of turning this functionality off unless it is inside a Workbook or VBA situation. If not then this presents a serious security hole. Thanks. John. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Query security
John Nordien wrote ...
Is there a way to have the functionality of Microsoft Query and yet prevent a user from creating a new database connection & query that would allow access to records for editing? There must be a way of turning this functionality off unless it is inside a Workbook or VBA situation. If not then this presents a serious security hole. If you do not want the user/connection to be able to edit the data, ensure their permissions on the object (e.g. the table) are 'read only' in the database (e.g. if the datasource is an Excel worksheet, protect the worksheet with a password). Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security Update for Microsoft Office Excel 2007 (KB955470) | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
MICROSOFT QUERY | Excel Worksheet Functions | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Uaing VBA to query macro security level | Excel Programming |