ms access database

hi there, i created an access database that we'll use to enter basic information. I am not an access expert by any means, as a matter of fact for this project i'm reading books and watching videos so i can deliver. So the database serves our needs as simple as it is right now,  my question is this: is there a way to have the end user view the form without seeing all the ms access functions?  Let me explain better, when they open the access form they see all functions (capture1 attachment), i'd like them to see just the form (capture2 attachment).

i created it on ms access 2013 and it's intended to be used only on 1 computer. Your helpthis is what they see when they open the form is greatly appreciated.
jorge diazSEAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
probably you can consider to compile a MDE?

as a start for reading:

<link removed by SouthMod>

Converting a Microsoft Access Database to an MDE File
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
If you click File, then Options, and select the "Current Database" tab, you can disable alot of the design functionality.  In particular you want to look under "Ribbon and Toolbar options" (That is what its named in 2010 anyway) and disable the "Allow full Menus" and possibly also the "Allow default shortcut menus".

Note that after doing this, if you want to make design changes you need to open the app while holding down SHIFT.

Of course a user can also do the same. So if you want to prevent all design changes, then the solution is to save the file as a MDE file, and give that to the user. But this also means that you need to ensure that the application is split into a backend for the tables, and a frontend for the queries, forms and reports.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dale FyeOwner, Developing Solutions LLCCommented:
Here is the code I use to hide and display the navigation pane and the ribbon.  To hide those to items, simply use the line:

Display False

I have a line of code in the Close event of my splash form which checks to see whether I'm in debugging mode or not.  If so, then when that form closes it makes those two items visible again:

If bDebugging = true then Display True

Public Sub Display(Optional IsVisible As Boolean = True)

    DisplayNavPane IsVisible
    DisplayRibbon IsVisible
End Sub

Public Sub DisplayNavPane(Optional IsVisible As Boolean = True)

    Dim strTableName As String
    On Error GoTo DisplayNavPaneError

    strTableName = ""
    DoCmd.SelectObject acTable, strTableName, True

    If IsVisible = False Then
        DoCmd.RunCommand acCmdWindowHide
    End If

    Exit Sub


    If Err.Number = 2544 Then
        'Get the name of the first table in the mSysObjects table
        strTableName = DLookup("Name", "mSysObjects", "[Type] = 1 AND [Flags] = 0")
        MsgBox ("Error encountered in DisplayNavPane subroutine!")
        Resume ProcExit
    End If

End Sub

Public Sub DisplayRibbon(Optional IsVisible As Boolean = True)

    Dim intAction As Integer
    If Application.Version < 12 Then
        'do nothing
    ElseIf IsVisible Then
        DoCmd.ShowToolbar "Ribbon", acToolbarYes
        DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End If
End Sub

Open in new window

IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can also change the file extension to .accdr and deploy that. Access detects this as a "runtime" file, and will show the user the "runtime" view (which disables the ribbon, among other things). Of course, this means you'll need to provide navigation methods to the user - either create a Ribbon, or use a Menu form, etc.
Dale FyeOwner, Developing Solutions LLCCommented:
Also, if you use the runtime (.accdr) , you will lose all right click (shortcut) menus unless you make a number of modifications to your applications.
jorge diazSEAuthor Commented:
thank your for all your help. I'll hide the options for now until i'm able to converted into a mde as some suggested.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.