How to remove access to elements

[arm1]

I was hoping someone could let me know how I can convert my MS ACCESS database file (.mdb) so that when user(s) run/open the database, they cannot see, nor have access to the tables (which are linked from a separate DB with just the tables), forms, queries, etc... (the elements). Right now, you can open the file, the switchboard runs, but you can still see and navigate to the tables/forms/queries seen in the background.

Is there a quick and simple way to turn this into an executable-type file where you cannot see the elements in the background?

 

[Matt Greatorex]

This link may help you.

http://www.access-programmers.co.uk/forums/showthread.php?t=115646&highlight=hide+database+window

 

[arm1]

I have tried things like unchecking the database window, and this does remove the view to the background elements (like tables, forms, etc...) for the users. However, they can still go in to the same menu option and reenable it if they want.

Is there a way to hide these elements, compile the file into some kind of executable, and distribute it to the other users? That way, all they see is the switchboard (which opens on execution). There is no menu options, no possible changes to the database possible, only USE?!?

Thank you for all your replies... I am still trying them all to see which best fits this issue. Thank you again.

 

[boblarson]

No, there is no way to turn it into an executable. However, if you don't want certain things to be seen, you can either:

1. create an MDE file and then they can not get into design mode for your forms or code.

2. Use Access Security (do a search here on that term as there are tons of postings regarding that) which can allow you to limit users to who can access what.