Share via

Hiding tables, etc. in an executable access database

Anonymous
2018-06-22T16:32:57+00:00

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

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2018-06-22T16:45:12+00:00

    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.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2018-06-24T09:41:16+00:00

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

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-06-22T20:06:37+00:00

    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, ...

    Was this answer helpful?

    0 comments No comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2018-06-22T18:02:35+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2018-06-22T16:42:14+00:00

    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 >

    Was this answer helpful?

    0 comments No comments