Protection

[duvenhlc]

Please give advice

How can I prevent someone to export tables & queries. If I open a blank database, I can import all my tables and queries into with the "get external data" command. How can I block this. I did setup the permissions and does not seems to work.

Thanks

 

[gemma-the-husky]

i wouldnt worry about this too much

just protect the code - use an mde


most apps expose their tables via sql drivers, or directly.
queries are pretty obvious anyway.

in some ways it is useful if users can connect to the data externally, to extract data for different things, as long as they know they shouldn't update it.