Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgresql and MSACCESS

Postgresql and MSACCESS

From
DI Irina Hasenöhrl
Date:
hello,
 
i'm a beginner on postgresql but i'm familar with Msaccess.
I use postgresql 7.0.2 as backend and i has to decide whether to use Msaccess 97 or access2000 for the frontend.
It's the first time, i'm working with ODBC.
I use ODBC 6.5 and i use the following settings:
    Data Source:   
                           read only:               no
                           show system tables: no
                           Row versionoing:     no
                           OID options:            show column: no
     Drivers:
                           disable genetic optimizer:  yes
                           keyset query optimizer:     yes
                           recognize unique indexes: yes
                           use declare/fetch:             no
                           common log:                     no
                           read only:                         no
                           parse statements               no
                           cancel as freestmt:            no
                           unknown size:                   longest
                           data type options:              text as long varchar
 
I hope, someone can help me and let me know some useful links or insider tips and tricks to use msaccess
 
Many thanks in advance
Irina

Re: Postgresql and MSACCESS

From
Joel Burton
Date:
On Wed, 7 Mar 2001, [iso-8859-1] DI Irina Hasen�hrl wrote:

> I hope, someone can help me and let me know some useful links or insider tips and tricks to use msaccess

There's a FAQ for PostgreSQL + Access at www.scw.org/pgaccess.


-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington