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.

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.

--