How to disable the home menu in access 2007

Method #1

 Click the Office button in the top right corner, then in the bottom right corner of the drop down menu should be an "Access Options" button. Click this to bring up the properties. Select the Current Database tab, scroll down to Ribbon and Toolbar Options and untick Allow Full Menus and Allow Default Shortcut Menus.
Method #2
Click the Office button in the top left corner, then in the bottom right corner of the drop down menu should be an "Access Options" button. Click this to bring up the properties. Select the Current Database tab, scroll down to Ribbon and Toolbar Options and untick Allow Full Menus and Allow Default Shortcut Menus.

You might also want to consider hiding the Document Tabs and disabling the Access Special Keys (in the Application Options area of Current Database).

Hope that helps
---------------------------------------------------------------------------------------------------------------------------------------

How to Reset Full Menu Option For Database On Startup


 https://bytes.com/topic/access/answers/594587-how-reset-full-menu-option-database-startup

 So you can't actually get to the Startup screen at all atm?
Not good.
There are some tricks to try but it is possible to leave a database completely protected if you're not careful and never be able to access it again.
  • Try holding down the bypass (Shift) key while opening the database.
  • Try using Ctrl-Break while the system is running to see if it will allow the operator into the Debug window.
Whenever protecting a database like this always leave yourself a back-door. I know this is a bolted horse scenario but it won't hurt to make the point anyway.
Let me know how you get on.

Comments

Post a Comment

Popular posts from this blog

MS Access: export a query to Excel with Docmd.Output

Image
https://codedocu.com/Details?d=2136&a=8&f=319&l=0 Download: Datei 1:  Access_Export_Query.accdb Datei 2:  Output_Results.xlsx The example shows how to export an Access query to Excel. The query contains current data from a table, which was filtered by a radio button. For this you use the command Docmd.OutputTo in Microsoft Access As DoCmd.OutputTo acOutputQuery,  "qryCars_Sale" , acFormatXLSX, ,  True When executing the OutputTo command, a Save dialog box is automatically displayed which would like to save a document in Excel. DoCmd.OutputTo acOutputQuery,  "qryCars_Sale" , acFormatXLSX, ,  True The acOutputQuery parameter indicates that a query is in the third parameter. The query query is bound to the form that is currently open and uses a radio button. If you want to output the output directly into a named Excel file, then you have to name the Excel file name with the foll path Dim ...
Read more

Export Access Object to Excel ,PDF, RTF , etc. using DoCmd.OutputTo

Microsoft Access allows us to export access object like table, query ,etc to other formats like Excel, PDF, RTF , etc. Using “DoCmd.OutputTo” To know about DoCmd.OutputTo visit the below link http://msdn.microsoft.com/en-us/library/aa141534(v=office.10).aspx Syntax DoCmd.outputto ObjectType, ObjectName, OutputFormat, Output file, Autostart, Templatefile, encoding, ObjectType – acOutputTable( to output table), acOutputquery(to output query),acoutputreport(to output report),ascendform(to output form), acOutputModule(to output module) ObjectName – Name of table, query, Report etc. OutputFormat – acFormatHTML ,acFormatRTF ,acFormatSNP,acFormatTXT ,acFormatXLS, acFormatXLSX , acFormatPDF , etc. Output file – Complete path of output file eg. C:\ abc.xls  or d:\ abc.pdf  Keep it blank if you want to save at run time. AutoStart Optional Variant Templatefile – The full name, including the path, of the file to use as a template for an HTML file Encoding- Optional Variant  ...
Read more

HOW TO OPEN ACCESS IN FULL SCREEN: OPENING A FORM AS MAXIMIZED ?

Image
https://accessdatabasetutorial.com/open-access-database-full-screen-opening-form-maximized/ Once users get a grip on form design techniques in  Microsoft Access database , they normally want to jump ahead and customize forms in their applications that appear polished and professional. One technique they can use is to  open Access in full screen  view which hides other no essential screens keeping your database neat and tidy. It requires a combination of setting various form properties during the design time mode and optionally (but ideally) applying either macros or VBA code  to the form’s module too. The final touches to this process would be to create a desktop icon shortcut to load the database file and run the assigned AutoExec macro to the application which will  open  Access Database  in full screen  hiding non-essential components. How To Open Access In Full Screen: Opening A Form As Maximized Create your form in design view...
Read more