Creating a New Database in PCRecruiter


PCRecruiter Windows Version

New Access format database:

1. Log into PCRecruiter
2. Open the 'Utilities' menu
3. Select 'Create New Database'.
4. Click the Red Square and use the BlankNR database.
5. Click the Blue Square and give the new database a name. This is the name that will appear in the dropdown on the login screen.
6. Click the Orange Square and select a location for the database file. Give the new database a name. Use the same name as in the previous step.
7. Click Green Square to complete the process.
8. You may now use the "Select Another Database" item in the "Database" menu to test out your new database connection.

New SQL format database:

1. Log into PCRecruiter
2. Open the 'Utilities' menu
3. Select 'Create SQL Connection'.
4. Click on the 'Create Database' tab.
5. Fill in the following information:
   1. Description: Give the database a name. This name will appear in the dropdown menu on the login screen.
   2. Server: Enter the server’s IP address (e.g. 192.168.0.1)
   3. Database Name: Select the name for the database. This can be the same as the name selected for the 'Description' above. This is also the name that this database will bear in the SQL Enterprise Manager.
   4. Database Path: Use the 'Default' path in the dropdown.
   5. Backup UNC: Use the automatically defined path or specify a location.
   6. Click 'OK'
6. You will be prompted to enter your SQL password as provided to you by Main Sequence Technologies.
7. You may now use the "Select Another Database" item in the "Database" menu to test out your new database connection.

PCRecruiter Web Version

New Access format database:

1. In the PCRecruiter Web application, click "System" in the main menu.
2. Select the "Console: Data Locations/System Setup/Utilities" option.
3. Choose "Create New Database"
4. Select "Create New MS-Access® Database" and fill in the fields as follows:
   1. Database Description: Give the database a name. This name will appear in the dropdown menu on the login screen.
   2. Database Name: Select a name for the actual database file, usually the same as the description entered above.
   3. User Name: Create an administrative username for the new database
   4. Password: Choose a password for the selected username
   5. Copy from Other DB: Select an existing database to use as a template if you wish, or select 'Use Blank Database'.
5. Click "Save" to complete the process.

New SQL format database:

1. In the PCRecruiter Web application, click "System" in the main menu.
2. Select the "Console: Data Locations/System Setup/Utilities" option.
3. Choose "Create New Database"
4. Select "Create New SQL Server® Database" and fill in the fields as follows:
   1. Database Description: Give the database a name. This name will appear in the dropdown menu on the login screen.
   2. Database Name: Select a name for the actual database file, usually the same as the description entered above. This is also the name that this database will bear in the SQL Enterprise Manager.
   3. Network: Select "TCP/IP" unless otherwise instructed.
   4. Server IP/Name: Enter the name or IP address of your SQL server
   5. SQL User Name: Enter the SQL administrator name (default is "SA")
   6. SQL Password: Enter the password for the username entered above.
5. Click "Save"
6. The screen will reload with the database path and backup path filled in.
7. Enter the authorization code provided to you by Main Sequence Technologies.
8. Click "Save" to complete the process.