![]() ![]() This button will get you and your users back to the same “Access Options”, so beware, they are not totally locked out using just this method. Even though you won’t see the “Access Options” button that got you here, in version 2010, there is a button for “Privacy Options”.It will also remove most of the entries under the File tab. Turn off Full menus: This will remove most of the tabs from your ribbon.Hide the Navigation pane: This will hide access to our database objects such as tables, forms, reports, queries, and code modules.Then choose “Access Options” near the bottom-left, and then choose “Current Database” on the left. Each of these items can be modified by going to the Office button in version 2007, or the File tab in versions 20. Here are several things we can to restrict access to the design features that Access provides by default. ![]() As to your original copy, heed Gandalf the Grey’s advice and “keep it secret, keep it safe”. So make a copy of your database and only secure the copy. Prevent Design Changes to Your User Interfaceīefore you make any changes that will lock your users out of the design-time features provided by Access, remember that if you lock them out, you also lock yourself out. Then password protect your back-end database, and hide the Navigation pane in your front-end. This second method makes an additional case against users directly editing tables.Ī great way to prevent user access to data is to split your database, thus putting your data tables in one database file (the back-end), and your user interface in another database file (the front-end). Another method of managing this is to embed business rules in our data entry forms. One method of managing this is via relationships between tables, data integrity enforced by the database. In addition, there is often rules that govern how data elements should be related to one another. Prevent our users from modifying the design of our database objectĪllowing a user to directly edit a data table is to invite the potential for additional accidental data edits, or even unplanned mass data deletions.Look at how to keep our users from directly editing our tables.Accidental changes to any of this, could seriously impact the functionality of your application, therefore, we want to keep untrained people out of the design features that are, by default, provided by Access. More than likely, you’ve spent considerable time tweaking the design of your forms, tables, queries and reports to work together to create the user experience and functionality you desire. The design of an Access application can be a fragile thing. Protect Your Microsoft Access Applicationsįrom Direct Table Editing and Changing Your Design This is the companion blog entry for the video:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |