You should now be connected to the database. This will add the required project field to all tables in the database automatically. Leave all of the default fields as they are.Ĭlick 'Add Project Field To Database'. Give the Database Settings File a name (this file contains the information needed to connect to the database) Select MSAccess as the data source type, and then browse to your databaseĭoes this database use a system database for security = No
#Surpac geology datbasde full
There are a few other tables that Visual Geobase requires, but the program will create these automatically.įor a full description of the data format specification go here : Visual Geobase Data Format Specification Procedure If you have a Surpac format database you need to link to, simply add a Project field to each table and give the field a value like 'My Project' and Visual Geobase will be able to read the database directly. This field groups the boreholes into separate projects. The principle difference between a Visual Geobase format database and a Surpac format database is that Visual Geobase requires a 'Project' field in every table. Linking to an existing Surpac format database (.mdb) Whether connecting to a database which has been created using Surpac or one created independently, a database definition file is required to read/write to the database Put simply, a database definition file (. Its best to leave the field names as they are if you are planning to use Visual Geobase with Surpac. E.g if you have changed the 'hole_id' fields to something like 'BoreholeName' you will need to make the correct name mapping in Surpac. Note that if you have changed any of the Surpac required field names from the default field or table names created by Visual Geobase, you will need to map the new names from within Surpac, to the correct required field names.
To use Surpac to link to an existing Visual Geobase Format Database All that is required to read the data directly from the Visual Geobase database into Surpac Vision is the following: 1. The default database format used by Visual Geobase is directly compatible with Surpac Vision.
0 kommentar(er)
