PgVBAccess User's Guide

by the PgVBAccess Team

Contents

• Contents
• 1. Introduction
  • 1.1 Purpose of this User Guide
    • 1.1.1 What is PostgreSQL 7.1 ?
    • 1.1.2 Why should I use it with Microsoft Access ?
  • 1.2 Conventions used in this User Guide
  • 1.3 Contributors to this manual
• 2. Installing core applications
  • 2.1 Installing PostgreSQL 7.1
    • 2.1.1 Getting PostgreSQL 7.1
    • 2.1.2 Installating from RPMs
    • 2.1.3 Starting the Postmaster and testing the database
    • 2.1.4 Configuring simple security
    • 2.1.5 Allowing socket connexions for odbc
    • 2.1.6 Howtos
  • 2.2 Installing Microsoft MDAC 2.5 sp1
    • 2.2.1 Getting MDAC 2.5 sp1
    • 2.2.2 Installing MDAC 2.5 sp1
  • 2.3 Installing PostgreSQL Odbc driver
    • 2.3.1 Getting the odbc driver for PostgreSQL
    • 2.3.2 Installating the driver
    • 2.3.3 Configuration of the driver
    • 2.3.4 Upgrading the drivers
    • 2.3.5 Howtos
• 3. Installing Helper Applications and Tools
  • 3.1 Why should I need Helper applications and tools ?
  • 3.2 System administration tools
    • 3.2.1 Linuxconf
    • 3.2.2 VNC Server
  • 3.3 Database administration tools
    • 3.3.1 Linux PgAdmin - The linux administration interface
    • 3.3.2 Windows PgAdmin - The Windows administration interface
    • 3.3.3 PhpPgAdmin - The Html administration interface
  • 3.4 Query editors
    • 3.4.1 Using Linux PgAdmin
    • 3.4.2 Writing queries within Microsoft Access
    • 3.4.3 Writing queries with PhpEd
• 4. First Tutorial - Getting married.mdb case study
  • 4.1 Purpose of this tutorial
  • 4.2 Migrating Lovers.mdb
    • 4.2.1 Migrating tables with PgAdmin
    • 4.2.2 Attaching tables in Microsoft Access
  • 4.3 Working with Lovers.mdb
    • 4.3.1 Creating new fields and indexes
    • 4.3.2 Searching and updating the database
    • 4.3.3 Backing-up and restoring the database
• 5. Second Tutorial - Lovers.mdb database case study
  • 5.1 Purpose of this tutorial
  • 5.2 Writing complex join queries
  • 5.3 Using pass-through querries
• 6. Where do I go now ?
  • 6.1 PostgreSQL Administration Guide
  • 6.2 PostgreSQL Programming Guide
• About this document ...

1. Introduction

1.1 Purpose of this User Guide

1.1.1 What is PostgreSQL 7.1 ?

1.1.2 Why should I use it with Microsoft Access ?

1.2 Conventions used in this User Guide

1.3 Contributors to this manual

2. Installing core applications

2.1 Installing PostgreSQL 7.1

2.1.1 Getting PostgreSQL 7.1

2.1.2 Installating from RPMs

2.1.3 Starting the Postmaster and testing the database

2.1.4 Configuring simple security

2.1.5 Allowing socket connexions for odbc

2.1.6 Howtos

2.1.6.1 How do I upgrade to future versions of PostgreSQL 7.x ?

2.1.6.2 How do I build PostgreSQL from Source ?

2.1.6.3 What are the available Postmaster startup options ?

2.2 Installing Microsoft MDAC 2.5 sp1

2.2.1 Getting MDAC 2.5 sp1

2.2.2 Installing MDAC 2.5 sp1

2.3 Installing PostgreSQL Odbc driver

2.3.1 Getting the odbc driver for PostgreSQL

2.3.2 Installating the driver

2.3.3 Configuration of the driver

2.3.4 Upgrading the drivers

2.3.5 Howtos

2.3.5.1 How does the PostgreSQL driver compare with drivers from legacy applications ?

2.3.5.2 How do I build the driver from source ?

2.3.5.3 What are the available ODBC connexion options ?

3. Installing Helper Applications and Tools

3.1 Why should I need Helper applications and tools ?

3.2 System administration tools

3.2.1 Linuxconf

3.2.1.1 Getting Linuxconf

3.2.1.2 Installing Linuxconf

3.2.1.3 Using Linuxconf with PostgreSQL

3.2.2 VNC Server

3.2.2.1 Database administration tools

3.2.2.2 PgAdmin - The Windows administration tool

3.2.2.3 PhpPgAdmin - The html universal administration tool

3.3 Database administration tools

3.3.1 Linux PgAdmin - The linux administration interface

3.3.2 Windows PgAdmin - The Windows administration interface

3.3.2.1 Getting PgAdmin

3.3.2.2 Installing PgAdmin

3.3.2.3 Running PgAdmin

3.3.3 PhpPgAdmin - The Html administration interface

3.3.3.1 Installing Apache from RPMs

3.3.3.2 Installing Php from Troels Arvin RPMs

3.3.3.3 Installing PhpPgAdmin

3.4 Query editors

3.4.1 Using Linux PgAdmin

3.4.2 Writing queries within Microsoft Access

3.4.3 Writing queries with PhpEd

4. First Tutorial - Getting married.mdb case study

4.1 Purpose of this tutorial

4.2 Migrating Lovers.mdb

4.2.1 Migrating tables with PgAdmin

4.2.2 Attaching tables in Microsoft Access

4.3 Working with Lovers.mdb

4.3.1 Creating new fields and indexes

4.3.2 Searching and updating the database

4.3.3 Backing-up and restoring the database

5. Second Tutorial - Lovers.mdb database case study

5.1 Purpose of this tutorial

5.2 Writing complex join queries

5.3 Using pass-through querries

6. Where do I go now ?

6.1 PostgreSQL Administration Guide

6.2 PostgreSQL Programming Guide

About this document ...

PgVBAccess User's Guide

This document was generated using the LaTeX2HTML translator Version 99.2beta8 (1.42)

Copyright © 1993, 1994, 1995, 1996, Nikos Drakos, Computer Based Learning Unit, University of Leeds.
Copyright © 1997, 1998, 1999, Ross Moore, Mathematics Department, Macquarie University, Sydney.

The command line arguments were:
latex2html -no_subdir -split 0 -show_section_numbers /tmp/lyx_tmpdir1319ndByZN/lyx_tmpbuf1319g7CCvK/PgVBAccess.tex

The translation was initiated by root on 2001-03-18