Creating and setting the product library as a personal or file geodatabase (Aeronautical Solution)

Using a personal or file geodatabase allows you to create a local database that can be placed on a network location and accessed by a limited number of users. The following process outlines the steps for creating a personal or file geodatabase that can then be used as a product library.

Creating a new personal or file geodatabase

A new personal or file geodatabase needs to be created to be used as the product library.

You can create a new personal or file geodatabase in ArcMap in the Catalog window.

Steps:
  1. Start ArcMap.
  2. Click the Catalog Window button Catalog on the Standard toolbar to open the Catalog window.
  3. Navigate to the location where you want to create the new geodatabase.
  4. Right-click the folder in the Catalog tree where you want to create the new geodatabase, point to New, then click one of the following:
    • Personal Geodatabase—If you want to create a personal geodatabase
    • File Geodatabase—If you want to create a file geodatabase

    A new geodatabase is created in the location you selected.

  5. Type the name for the new geodatabase.
    TipTip:

    You can also rename the new geodatabase by right-clicking the new geodatabase name and clicking Rename.

Defining and upgrading the geodatabase as a product library

After the geodatabase has been created, various tables and feature classes that are part of the product library need to be added to it. This process can be completed in ArcMap. The tables and feature classes are created under the schema that is owned by the user that is connected. The user must be the owner of the schema that was used to create the product library to be able to upgrade and create or delete product classes. To allow other users to be the schema owner, the properties need to be changed in Microsoft SQL Server Management Studio.

When no product library workspace is defined, and you add data that is stored in a geodatabase, which is a product library and a production database, the product library workspace points to this geodatabase; the data model versions are also set automatically.

The steps in this section are for defining and upgrading the geodatabase as a product library in ArcMap.

Steps:
  1. On the menu bar, click Customize > Production > Product Library.
    TipTip:

    If the Product Library command is not enabled, you may need to enable the Production Mapping extension by clicking Customize > Extensions and checking the check box for Production Mapping.

    TipTip:

    You can also open the window by clicking the Product Library button Product Library window on the Production Cartography or Production Editing toolbar.

  2. Right-click Product Library and click Select Product Library.

    The Choose Product Library Workspace dialog box appears.

  3. Navigate to the product library database.
  4. Click Open.

    The Upgrade Product Library Workspace or the Create Product Library Workspace dialog box appears if the geodatabase does not have all the components necessary to perform as a product library. Continue to step 5 if one of these dialog boxes appears.

    NoteNote:

    If you also have the Maritime Charting installed, tables are added to the product library schema that are necessary for nautical production but do not impact non–nautical production.

    If this is not a new product library, and if an error appears when you choose a geodatabase as the product library, it may need to be compacted or compressed to restore its integrity. Compacting applies to personal and file geodatabases, and compressing applies to enterprise geodatabases.

  5. Perform the following steps if you want to upgrade or create the geodatabase you want to use as the product library.
    1. If necessary, click the drop-down arrow in the Select Configuration Keyword area and choose an option.

      Options vary based on whether the database is a personal, file, or ArcSDE geodatabase.

    2. Click OK.
    3. Click OK once the upgrade or creation completes.

Granting permissions to the database

When the product library is a personal or file geodatabase, all users have the same level of access and permissions. Access to the product library is managed by Windows login authentication.

When a nonadministrative user is going to be setting and using the product library database, the system administrator needs to provide the following permissions for that user:

Full Control for the database

Example of Full Control permissions on a database, as set on the Security tab

Full Control for the directory that contains the database

Example of a directory with Full Control permissions, as set on the Security tab
12/22/2014