Thread: Interface

Interface

From
"Mike Hammonds"
Date:
** Reply Requested When Convenient **

Is anybody using MS Access as an interface to PgSQL in a network environment?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office:  502.426.4500 Ext. - 7389
Fax:      502.426.8800
mhammonds@knowledgeinenergy.com


Attachment

Re: Interface

From
Date:
Yes, on a very small scale.  MSAccess97 on NT4.0 workstation and Win98
clients.  Postgres 7.0-2 on RedHat 6.0 server.  . . . Works great!

David Boerwinkle

-----Original Message-----
From: Mike Hammonds <mhammonds@knowledgeinenergy.com>
To: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Date: Monday, November 13, 2000 9:13 AM
Subject: [NOVICE] Interface


** Reply Requested When Convenient **

Is anybody using MS Access as an interface to PgSQL in a network
environment?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office:  502.426.4500 Ext. - 7389
Fax:      502.426.8800
mhammonds@knowledgeinenergy.com




Re: Interface

From
"Mike Hammonds"
Date:
** Reply Requested When Convenient **

Did you have to do any custom configurations to get it to work?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office:  502.426.4500 Ext. - 7389
Fax:      502.426.8800
mhammonds@knowledgeinenergy.com

>>> <davidb@vectormath.com> 11/13/00 11:45AM >>>
Yes, on a very small scale.  MSAccess97 on NT4.0 workstation and Win98
clients.  Postgres 7.0-2 on RedHat 6.0 server.  . . . Works great!

David Boerwinkle

-----Original Message-----
From: Mike Hammonds <mhammonds@knowledgeinenergy.com>
To: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Date: Monday, November 13, 2000 9:13 AM
Subject: [NOVICE] Interface


** Reply Requested When Convenient **

Is anybody using MS Access as an interface to PgSQL in a network
environment?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office:  502.426.4500 Ext. - 7389
Fax:      502.426.8800
mhammonds@knowledgeinenergy.com





Attachment

Re: Interface

From
Date:
custom configurations ?
Yes, uncheck "read only" in the ODBC driver.
Also, I have found that the MSAccess forms need to be changed to work with
Postgres.  For example, I couldn't get subforms to work.  Others may
disagree with this assessment.
Are you having some specific problem?

David Boerwinkle
-----Original Message-----
From: Mike Hammonds <mhammonds@knowledgeinenergy.com>
To: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>;
davidb@vectormath.com <davidb@vectormath.com>
Date: Monday, November 13, 2000 2:09 PM
Subject: Re: [NOVICE] Interface


** Reply Requested When Convenient **

Did you have to do any custom configurations to get it to work?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office:  502.426.4500 Ext. - 7389
Fax:      502.426.8800
mhammonds@knowledgeinenergy.com

>>> <davidb@vectormath.com> 11/13/00 11:45AM >>>
Yes, on a very small scale.  MSAccess97 on NT4.0 workstation and Win98
clients.  Postgres 7.0-2 on RedHat 6.0 server.  . . . Works great!

David Boerwinkle

-----Original Message-----
From: Mike Hammonds <mhammonds@knowledgeinenergy.com>
To: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Date: Monday, November 13, 2000 9:13 AM
Subject: [NOVICE] Interface


** Reply Requested When Convenient **

Is anybody using MS Access as an interface to PgSQL in a network
environment?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office:  502.426.4500 Ext. - 7389
Fax:      502.426.8800
mhammonds@knowledgeinenergy.com