Microsoft Query security

[Guest]

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.

 

[Jamie Collins]

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.

--