Re: psqlodbc MSAccess and Postgresql

<Typing80wpm(at)aol(dot)com> wrote in message news:19f(dot)324000cd(dot)2f99d761(at)aol(dot)com(dot)(dot)(dot)
> Thanks for the help with /dt... Mike, your post helped me to discover psql
> command window, I had been trying out the pgAdmin ...
>
> I found an interesting article regarding MSAccess as a front end to
> Postgresql, so I downloaded the psqlodbc installer. I will be getting up
> the nerve
> to run the install and go into windows odbc and install that driver so I
> can
> use MSAccess with Postgresql ... any tips or caveats appreciated....

Be sure to check out the FAQs and How-tos at the psqlodbc project site:
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

You will find that that Access and PostgreSQL get on well together. You can
get by with the default driver settings for the most part; I suggest that
you make sure that the "row versioning" and "true = -1" options are set to
true. If you want to use the "memo" datatype in Access, then you will need
to check "text = longvarchar" option.

If you have further questions, try posting to the pgsql-odbc list.

>
> This is the link which is guiding me....
> _http://database.sarang.net/database/postgres/postodbc/faq.html_
> (http://database.sarang.net/database/postgres/postodbc/faq.html)
>
>
>