Show only the Switchboard & through it access the Forms & Reports only in access db.

[recyan]

Is it possible to allow the user to see only the Switchboard on opening the db?
Rest nothing should be visible to the user.
The user should not be able to access or use "Customize Quick Access Toolbar..".



In short, the user should be able to run the application for the purpose for which it has been designed & nothing beyond that.

Thanks

[recyan]

Will below do the necessary ?

Source :
http://www.access-programmers.co.uk/...d.php?t=217085

An AutoExec Macro which runs the below code

Function AutoExec()
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.RunCommand acCmdWindowHide
End Function

To me it appears to be doing what I want, but would appreciate a look at it from your eyes.

Thanks

[recyan]

Which comes first, the hen or the egg?

Facing a tricky situation on using the method in previous post.
When I open the application, the Autoexec does not run till I enable the Options "Enable this content".
On enabling this, the application goes in to the Toolbar, Navigation bar, etc Disabled mode.

The problem is, I am trying to convert the db in to accde via "Make ACCDE" button.
If I try without enabling "Enable this content", I get a message :

"You cannot create an .accde or .mde file from a disabled (non-trusted) database. If you trust the source of this database, you can enable it by using the Message bar."

And if I enable "Enable this content", I loose the "Make ACCDE" button.

1) Any cheat ways, to get both things done ?

Edit : 2) While on the topic of ACCDE, what is the purpose of password protecting, before converting to ACCDE ?

Thanks

[recyan]

1) Question 1 - Solved :
Was a simple cheat.
Did not enable "Enable this content".
Disabled the content in the Code by single quoting ( forgot what this is called) & gave a MsgBox Alert "Hi", for the AutoExec to feed on.
Enabled "Enable this content".
Got a "Hi". Clicked OK.
Enabled the content of the Code by removing the Single Quotes. Saved. Converted to ACCDE. Bingo. Got the best of both the worlds ( I think / hope so ).

2) Question 2 - Pending: 2) While on the topic of ACCDE, what is the purpose of password protecting, before converting to ACCDE ?

Hope my blabbering makes sense to you guys / gals

Thanks