MS Query security issue

[christos52]

Hi,

I am experimenting with EXCEL pivot tables to allow users access to my ACCESS DB for mass extracts of data at their request. Excel uses MS QUERY to setup the data connection which works fine into an MDB or MDE. However I was very surprised that MS QUERY allows you to update the data and this is reflected in the DB.

I now think I may have opened a can of worms and should insist that all data is extracted by the Access application.

Does anyone have experience of MS QUERY and know if I can easily prevent users updating my DB? I can protect the data DB using a password but always thought an MDE was a safe way of going as a front end.

Christos.

 

[Guus2005]

The MDE protects code only. Not Data.

To protect your data you can:
Create a copy instead of the original database, thus protecting the data.
You can protect the database by setting a password for the database
You can set the admin password, create groups and assign people to these groups. Then assign each group some rights.

The first choice would be mine. Simple and easy to maintain.

HTH