RE: data entry

From: patrick(dot)wolf(at)Aerojet(dot)com (WOLF, PATRICK)
To: "'Poul Kristensen'" <bcc5226(at)vip(dot)cybercity(dot)dk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: RE: data entry
Date: 2000-09-05 21:48:23
Message-ID: 63A19D0F08E6D211AD740008C7B1C47B02FE168D@APD-MAIL1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)vip(dot)cybercity(dot)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(at)giaspn01(dot)vsnl(dot)net(dot)in]
> Sent: Tuesday, September 05, 2000 10:38 AM
> To: pgsql-novice(at)postgresql(dot)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
>
>
>

Browse pgsql-novice by date

  From Date Subject
Next Message Anthony E . Greene 2000-09-07 00:23:39 Re: data entry
Previous Message WOLF, PATRICK 2000-09-05 18:02:43 RE: data entry