GME

Geospatial Modelling Environment

access.summary (Access Database Summary)

Creates a simple summary description of an Access database (number of tables, number of columns and records in each table, a list of column names, etc)

Description

This tool creates a simple summary description of an Access database (number of tables, number of columns and records in each table, a list of column names, etc). It is intended as a tool to facilitate data exploration and report generation.

Syntax

access.summary(file);

filethe full path to the input database file (*.mdb)

Example

access.summary(file="C:\data\mydata.mdb");

Database: C:\data\mydata.mdb

Table count: 5

Table: Aquatic Ecosystem Health

Record count: 12

Field count: 9

Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup

Table: Base Maps

Record count: 80

Field count: 9

Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup

Table: Groups

Record count: 3

Field count: 2

Fields: Group Name, ID

Table: Land Use and Development

Record count: 48

Field count: 9

Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup

Table: MapFilesInfo

Record count: 185

Field count: 10

Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup, Visibility

Warning: Table names with spaces were detected. It is strongly recommended that you avoid the use of spaces in table names.

Warning: Column names with spaces were detected. It is strongly recommended that you avoid the use of spaces in column names.


Messages

Please consider making a purchase to support the continued development of these tools  Read more...

Tips on how to use this interface efficiently  Read more...

Links

Open Source GIS

Copyright © 2001-2014 Hawthorne L. Beyer, Ph.D., Spatial Ecology LLC    Connect on LinkedIn