Setting up a secure query in Excel

[sxschech]

I have set up some excel files to display data provided by MS-Query and would like to give the file to the users so that they can perform the "Data", "Refresh Data" themselves. However, for security reasons, would like to know if it is possible to prevent the users from clicking on "Data", "Import External Data" and clicking on "New Database Query" or "Edit Query"? ITS is concerned that the user could go in and then do a select *. ITS is handling security at the backend, however they pointed out that this still won't stop them from a select * on the tables they have permission to as they can't lock down specific fields.

 

[HarleyQuinn]

The easiest way to do this would be to (as Skip says) use ADO to retrieve the data rather than MS-Query.

You don't say what DB you're using but the ADO basics are pretty similar for all (the way you connect to the DB will be different for each though).

Set a reference to "Microsoft ActiveX Data Objects X.0 Library" in the VB Editor and you're ready to go and try them.

There are loads of tutorials on how to use ADO and the connection strings needed for specific DB's.

Post back if you need anything further detailing.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com