Hiding tables

J

JO

Would it be possible to keep the database window hidden with code, when
opening a database, and make an .mde file so user of an unsecured database
cannot work with tables or queries?
 
R

Rick Brandt

JO said:
Would it be possible to keep the database window hidden with code,
when opening a database, and make an .mde file so user of an
unsecured database cannot work with tables or queries?

Sort of. You can use the Startup options to hide the db window and disallow the
use of F11 to display it. You can execute a one-time code routine that will
disallow the use of the shift key when opening the file to curcumvent your
startup options. However, in an unsecured database anyone who knows how will be
able to re-enable the shift key option. Even if you uses security there are
hack programs availabel that will defeat that as well.

Bottom line is you can erect barriers. Very little work in doing so will keep
out 99% of people. NO amount of work can keep out the last 1%.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top