is that possible to have ms access application uses full-screen size

[asmdev]

hi,
i wonder is that possible for us, as a ms access user to use full-screen size :?
so that our ms access application wouldn't display any ms access menu or toolbar and others who use it don't know we are develop it using ms access.

and what is the best way or tips to prevent our application being modify by the end users? or made them unable to delete our query, table, report?

thanks in advance

[Br1an_g]

you can disable the toolbar, and a majority of the menu bar options using the 'Startup Options'

you can also code these options to prevent the user from getting into the database window.

further to that, you can create an MDE file to compile and lock any code.

theres a few good articles on MS.com about securing your database have a look over there.

probably the best way to do this is to set up user level security which allows you to set permissions at a group level.
http://support.microsoft.com/default...b;en-us;132143

[asmdev]

thanks,

[Ecniv]

Assuming you have no custom menu and you want access with a form already set in the start up options...

Add a reference to MS Office objects and use the following code...

Public Sub SetToolBarStatus(ByVal blnEnable As Boolean)
    Dim cmdBar As CommandBar
    
    On Error Resume Next
    
    For Each cmdBar In Application.CommandBars
        If Len(cmdBar.Name) > 2 Then
            If cmdBar.Name <> "Menu Bar" and cmdBar.Name <> " " Then cmdBar.Enabled = blnEnable
        End If
    Next

End Sub

Note it gets rid of all menus bars and pop up menus...

[asmdev]

hi encniv
but where should i place your SetToolBarStatus sub?
i place it in a Module
and i call it on the form which i set start-up (form_Load) event.
but i still able to see menu :?

[asmdev]

btw, i tried SetToolBarStatus(False) and SetToolBarStatus(True) em... but still the same? kind to enlight me a bit?