Hiding tables, etc. in an executable access database

Question

Is there an easy way of hiding tables, forms, reports and queries in an .accde executable database?

Answer 1

Forgot to add the following required disclaimer in my previous response

Required Forum Disclaimer:

The above link is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Answer 2

Thanks very much for all the suggested routes which I have followed and achieved what I wanted to do.

Answer 3

See http://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/For steps on how to secure an Access frontend.

Create your own ribbon, hide the nav pane, disable the shift bypass, create an AutoKeys macro to disable some of the default shortcut keys, ...

Answer 4

You can hide the Nav Pane and eliminate the Bypass key. If they can't get to the Nav Pane they can't see the tables.

Answer 5

You should take a look at the following post which discusses what I think you're asking

How to prevent users from opening database in design mode?

https://access-programmers.co.uk/forums/showthr...

In particular, scroll down the various posts and look at the answer from <haratianant >