Only view Navigation form??

[Kev_1988]

Hi

Is there a way that only open the "Navigation Form" at Form view and nothing more?
I know there is a way like Access > options > current database > display form
But you can still get access to tables, forms, queries even design view to edit anything.

Question, is there a way that you can set the "navigation form" that only gives you access to view(look) only?
So there is no way to go design view or different tables, forms or queries

Please let me know what the best way is to do it

Note: I'm a beginner with Access and VBA please be patient with me

Thanks a lot

 

[The_Doc_Man]

Generally, the Navigation form is just a link / pointer type of deal to each of the other objects. That is, it helps you find them. But the nature of the Access interface is such that if you have the object under-mouse, a right-click gives you the option to open it in any of the views available to it. Like, design view for anything that HAS a design view - which is most everything.

What you are asking to do is to make Access do something (or in this case, NOT do something) that is intrinsic to the operation of MSACCESS.EXE - and I have never seen any "hooks" in the program for that.

Part of your problem is this: While you CAN program your own ribbon to a limited sense, the navigation pane is NOT a form - so you can't reach into it and modify its behavior. It is the moral equivalent of asking Windows Explorer to let you see but not open files - without using security settings to accomplish that.

Oddly enough, before Microsoft dropped the use of MDAC and totally phased that out, you COULD have done something to make the objects read-only based on how the user opened the database - but (a) it was not even SLIGHTLY close to bullet-proof and (b) MDAC was SO buggy that it became a nightmare to maintain, which is why MS dropped it like the proverbial hot potato. In fact, it was so bad that it made #2 on the top-twenty list of the SAMS Institute's "Biggest Application Risks in Windows" for a few years running.

Back to your original question, I don't know of a way and because the Navigation pane is NOT a form, I don't think you can get to the code that would do what you might want.

That leaves you with "building your own" version by creating an opening form, hiding the ribbon and navigation pane, and using COM to visit all collections and build a tree-view diagram or something similar to do what you want to do. I'm a computer geek from the word "GO" and have 20 years of Access experience and I wouldn't even BEGIN to try this nightmare of a programming problem.