RE: data entry - Mailing list pgsql-novice

Poul,

There are really 3 pieces to it as I see it:

1)    get PostgreSQL running on your server with the -i option to support
internet sockets (see man postmaster). Configure pg_hba.conf to allow
connections from whatever host or hosts you want to run MS Access on (see
the pg_hba.conf file for info and examples).
2)    Load the ODBC driver on your Windows box (see
ftp://ftp.postgresql.org/pub/odbc/ for tips and the driver.  This driver was
being maintained by Insight Distributors, but they seem to have moved
everything to the postgresql site recently).
3)    Link the tables in MS Access and write your applications (read about
link tables in MS Access).

Of course, that being said, it took me some time and quite a bit of trial
and error to figure out all the particulars to make my apps work.

Pat


Patrick C. Wolf
Test Manager
Aerojet
Socorro Plant



        -----Original Message-----
        From:    Poul Kristensen [mailto:bcc5226@vip.cybercity.dk]
        Sent:    Tuesday, September 05, 2000 2:13 PM
        To:    WOLF, PATRICK
        Subject:    Re: [NOVICE] data entry

        VERY INTERESTING!

        How did you get through from MS Access to the PosgreSQL
database on the
        Linux server?

        TIA

        Poul

        Poul Kristensen
        The Danish National Institute of Social Research
        Copenhagen
        Denmark


        WOLF, PATRICK wrote:
        >
        > I've got several applications where I use a PostgreSQL
database running on a
        > Linux server with a MS Access front end application
running on the
        > individual PCs.  It was pretty painless to build, although
knowing something
        > about Access would have been nice, and it provides a nice
user interface for
        > the individuals that enter the data.  Then I have Perl CGI
scripts written
        > on the server to provide read only reports to the web
site.
        >
        > Pat
        >
        >
        > Patrick C. Wolf
        > Test Manager
        > Aerojet
        > Socorro Plant
        >
        >
        >
        >         -----Original Message-----
        >         From:    deval
[mailto:deval@giaspn01.vsnl.net.in]
        >         Sent:    Tuesday, September 05, 2000 10:38 AM
        >         To:    pgsql-novice@postgresql.org
        >         Subject:    [NOVICE] data entry
        >
        >
        >         For years I am using dBASE to compute
payroll of employees.
        > Required
        >         data entry is number of days present and
overtime if any.
        > This is done
        >         record by record. Data entry person sees
employee number and
        > name, and
        >         boxes with prompt, where the data is
entered. For Postgresql
        > is there
        >         any user interface available, that could
help a non
        > technical person to
        >         make the data entry?
        >
        >         vijay
        >
        >
        >