Multimedia Database Management System:

Instructions on the Use of the Pioneer Well Log MS-Access Database

(C. Asiala, J. Wood)

Pioneer Download Options

Overview

Loading the Pioneer well log collection into Microsoft ACCESS provides an easy, efficient means to archive and access the project well logs in LAS format. Access is readily available as a stand-alone program and Access files can be read by a number of applications, and the list is growing. By using the options (queries) available in Access, tables can be created that contain only the logs and wells of interest to the user. Several example Query files are provided.

The ACCESS log files created for this project have subsea depth in the left column and log curves in the columns to the right. The tables can be exported from Access in different formats, including text files and Microsoft Excel files.


Database File Organization

The Access database file and the LAS files for the Pioneer Project are in the LOGS subdirectory on this CD-ROM. These files contain:

1. 77 LAS files with raw log traces

2. 46 of these 77 wells contain computed (interpreted) log values.

3. 36 wells with well header information only (very old wells with wireline logs).

In the LOGS subdirectory, files which which end with "in" (*in.las) are computed (interpreted) logs, files labeled *.las files are raw logs and the file pioneer.mdb is the Microsoft Access for Windows 95 Version 7.0 database file.

The LAS files can be accessed from any Software Package that accepts the LAS format, but the user must have Microsoft Access for Windows 95 Version 7.0 in order to use the Pioneer Well Log Database provided on this CD-ROM.

Installation of the Pioneer Well Log Access Database.

To use the Pioneer Well Log Database, first copy pioneer.mdb from the LOGS subdirectory on the CD-ROM to a directory on your own harddrive.

(Remove Read-Only Property)

Then

  1. Start Microsoft Access and Open the database file, pioneer.mdb.

  2. Select the FORMS tab and Open PioneerForm to bring up the screen to view individual wells and to start the programs for creating the 2 types of tables. (Multiple Log Curves for Current Well or One Log Curve Over Multiple Wells)

  3. Select the TABLES tab and Open WellHeaders to view all the header information about the wells in the database.

  4. Select the QUERIES or REPORTS tabs to use the queries and reports present or create new ones of your own.


Creating Tables using PioneerForm

PioneerForm Options

  1. Select FORMS tab from database window.

  2. Open PioneerForm

  3. Select a specific well from WellName list if creating a table for Multiple Log Curves for Current Well.

  4. Enter drive and directory of location of LAS files (d:\logs if d is the CD drive letter)

  5. Click on either "Multiple Log Curves for Current Well" or "One Log Curve Over Multiple Wells"

If you select "Multiple Log Curves for Current Well", then
  1. Click on names in the Select Log Types list box to choose the Log Types to be included in the table.

  2. The new table generated will have the Subsea Depth in the first column and one column for each log chosen in the Select Log Types list box.

  3. The program generates a name shown on the bottom of the screen. ( a "W" followed by the LAS file name). The user can change this name.

  4. Click on the button called "Create Log Curve Table" to start the table generation. When complete, focus will go back to the PioneerForm screen and the table can be viewed under the TABLES tab from the main database screen.

If you select "One Log Curve Over Multiple Wells", then

  1. Click on one Log Name in the Log Curve list box to select one Log Curve for the table.

  2. Click the Select All Wells in List button to select all wells with the chosen Log Type, or

  3. Click on individual wells in the Select Wells for Curve list box to select only the wells needed. The wells shown in the Selected Wells for Log Curve list box will be included in the new table.

    Note: as wells are selected for the table, records are appended to a temporary table to hold for processing. The following messages will appear and both need to be responded to with a YES.

    "You are about to run an append query that will modify data in your table.
    Are you sure you want to run this action query?" Yes

    "You are about to append n row(s). Once you click Yes, you cant use the Undo command to reverse the changes.
    Are you sure you want to append the selected rows?" Yes

  4. The new table generated will have the Subsea Depth in the first column and one column for each selected well which holds the log values of the selected Log Type.

  5. The program generates a name shown on the bottom of the screen. ("LOG_ " followed by the 1-4 character Log Type name). The user can change this name.

  6. Click on the button called "Create Log Curve Table" to start the table generation. When complete, focus will go back to the PioneerForm screen and the table can be viewed under the the TABLES tab from the main database screen.

Database Definitions

Tables within the Pioneer Well Log Database file, pioneer.mdb

Table: WellHeaders

This table holds Well Header information for each of the 159 logs and/or wells in the study. The table is ordered by wells with raw logs first, then the wells with no logs, then the wells with computed logs. The well names for the wells with computed logs will be the same as the raw logs, but they will have "(INTERP)" appended to the end of the well name. INTERP was used as a shortened term for interpreted logs, but it will be changed to "(COMP)" on the second version of the CD-ROM.

When viewing the wells in the Form, PioneerForm, the wells will be shown in Well Name order for easier viewing. The attached reports give a list of the wells in the database and a field definition list for the fields in the WellHeaders table.

Table: LogsByWell2

This table holds general data about each log trace which is found in the LAS file for each well. The table is sorted by Well_ID and LogName. It is used by the programs for extracting log data by giving the top and bottom subsea levels of each log, and giving the place value of which column in the LAS file the log values are stored in.

Table: TempLogTable

This is a temporary table which holds the log trace names of which logs were selected for creating a table for Multiple Log Curves for Current Well. It is emptied before each use.

Table: WellsByLog2

This is also a temporary table which holds the wells which are selected with a commong log trace for creating a tabel for Multiple Wells for One Log Curve. It is also emptied before each use.


Forms within the Pioneer Well Log Database file, pioneer.mdb

Form: PioneerForm

This form which is shown under the FORMS tab in the database. Each Well can be viewed individually on this screen by choosing the well name from an alphabetic listing. General data about the well and a list of the log traces in the LAS file are displayed. The new log tables are generated from this screen.

Form: SelectLogs

This form appears when the user clicks on Multiple Log Curves for Current Well from the PioneerForm. Use the Select Log Types list box to choose the Log Traces to include in the table.

Form: SelectCurveAndWells

This form appears when the user clicks on One Log Curve Over Multiple Wells from the PioneerForm. Use the Log Curve list box to choose one Log Trace for the table. Use the Select Wells for Curve list box to select specific wells.


Queries within the Pioneer Well Log Database file, pioneer.mdb

GetLogList

Initiated from Form, Multiple Log Curves for Current Well
Fills Select Log Types list box with Log Types from current well.

ValidLogTypes

Initiated from Form, One Log Curve Over Multiple Wells
Fills Log Curve list box with valid Log Types from all wells.

GetWells

Initiated from Form, One Log Curve Over Multiple Wells
Reset when a Log Type is Clicked from the Log Curve list box.
Fills Select Wells for Curve list box with wells which have a log of the selected Log Type.

GetLASFiles

Initiated from Form, One Log Curve Over Multiple Wells
Called when Select All Wells in List button is pressed.
Fills Selected Wells for Log Curve list box with all wells which have the chosen Log Type.
Wells are appended to the WellsByLog2 table.

AddToWellList

Initiated from Form, One Log Curve Over Multiple Wells
Called when a well from the Select Wells for Curve list box is clicked.
Fills Selected Wells for Log Curve list box with one well at a time as they are chosen.
Wells are appended to the WellsByLog2 table.

FindDepthRange

Initiated from Module, OneCurveManyWells
Finds the Highest Top Depth and the Lowest Bottom Depth to initialize the table for One Log Curve Over Multiple Wells.

DeleteExample

This is an example of how a user can delete the half-foot and odd numbered depths from a table to decrease the size of the table. It can be altered to be used with any of the tables created from PioneerForm, and conditions may be changed, added, or deleted.

Query conditions

(Expression to determine if depth ends with .5)

Field : Expr1: [Subsea_Depth] - Fix([Subsea_Depth])

Delete : Where
Criteria : <> 0

(Expression to determine if depth is odd or even)

Field : Expr2: [Subsea_Depth] mod 2

Delete : Where
Criteria :
Or : <> 0

Modules within the Pioneer Well Log Database file, pioneer.mdb

ClearTempLogTable

Initiated from Form, Multiple Log Curves for Current Well
Called when Form is opened and also when the button, Clear Selected Log List is clicked.
Deletes all records in the TempLogTable

ClearWellsByLog2

Initiated from Form, One Log Curve Over Multiple Wells
Called when Form is opened and also when the button, Clear Selected Wells List is clicked.
Deletes all records in the WellsByLog2 table.

OneWellLogCurve

Initiated from Form, Multiple Log Curves for Current Well
Called when the Create Log Curve Table button is clicked.
Creates Table: First column is Subsea_Depth
Additional columns hold log values for each Log Type chosen

Reads the LAS file corresponding to the Current Well and fills the table with the selected Log values.

Table Name : first character is "W"
Followed by the LAS file name up to the .las

Field Names: Subsea_Depth and names of Log Types

OneCurveManyWells

Initiated from Form, One Log Curve Over Multiple Wells
Called when the Create Log Curve Table button is clicked.
Creates Table: First column is Subsea_Depth
Additional columns (1 per selected well) hold log values
for the Log Type chosen from each of the selected wells.

Reads the LAS files corresponding to the list of Selected Wells and fills the table with the selected Log values.

Table Name : First 4 characters are "LOG_"
Followed by 1-4 character log name

Field Names: Subsea_Depth and ("W" & LAS file names of wells)

Macros within the Pioneer Well Log Database file, pioneer.mdb

The Macros are called as a result of an event (a click of a button).

ClearTempLogTable
Calls Module to delete records from TempLogTable

ClearWellsByLog2
Calls Module to delete records from ClearWellsByLog2

OneCurveManyWells
Calls Module to create Table of Multiple Log Curves for Current Well

OneWellLogCurve
Calls Module to create Table of One Log Curve Over Multiple Wells

SelectCurveWells
Opens Form, One Log Curve Over Multiple Wells

SelectLogCurves
Opens Form, Multiple Log Curves for Current Well