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.
Capture2.JPG
LVL 7
jorge diazSEAsked:
Who is Participating?
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 ChongCommented:
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
http://www.databasedev.co.uk/microsoft-access-mde.html
0
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.
0

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 FyeCommented:
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

ProcExit:
    Exit Sub

DisplayNavPaneError:

    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")
        Resume
    Else
        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
    Else
        DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End If
    
End Sub

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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.
0
Dale FyeCommented:
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.
0
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.
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.