Thread: 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
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
** 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
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