Removing admin access to databases

Note  This feature is available when the Use advanced tools general preference is selected. See Using advanced tools.

You can use the Developer Utilities to remove all administrative account access from a file.

Important  Selecting this option permanently deletes from the database all account access entries that were using the Full Access privilege set. Structural and design elements of the files cannot be recovered. The only way to modify the tables, field definitions, relationships, scripts, or all access privileges is by returning to the original file before it was customized by the Developer Utilities.

To remove admin access to a database:

  1. Close all of your database files that you are going to customize.

  2. Choose Tools menu > Developer Utilities.

  3. If you have used the Developer Utilities on the same database before and saved your settings, click Load Settings.

  4. Click Add to locate the files that you want to customize.

  5. If you add multiple files, double-click a file in the list to specify the primary file.

  6. Select Developer Utilities settings as required. See Using the Developer Utilities.

  7. For Solution Options, click Specify. See Specifying options for the Developer Utilities.

  8. Select Remove admin access from files permanently and click OK.

Notes 

  • When you remove admin access:

    • Users can't access these dialog boxes: Manage Database, Manage External Data Sources, Manage Custom Functions, some Manage Security and most Advanced Security Settings.

    • Users can access the dialog boxes listed above if they run a script that is set to run with full access privileges. See Creating and editing scripts.

    • The text version of custom functions is removed.

    • Users can access the Manage Security dialog box if their account access has the Manage accounts that don't have Full Access privilege enabled. See Editing other privileges.

    • Users can access the Extended Privileges tab in Advanced Security Settings dialog box if their account access has the Manage extended privileges privilege enabled.

    • Users can access Layout mode and the Script Workspace if the privilege set assigned to their account permits it.

    • Users can't use the Developer Utilities to remove or change the encryption password for an encrypted file.