Postgres Pro
Downloads
Home   >   mailing lists

Thread: documentation on using PostODBC?

documentation on using PostODBC?

From
WAGNERP@UWSTOUT.EDU
Date:
Is there user documentation on how to *use* PostODBC, specifically on how to
access a PostreSQL database from MS Access?  I've got PostODBC itself
downloaded/installed, and have set up a PostgreSQL data source, but am not
sure what needs to be done to allow MS Access to connect to and manipulate
this data source.  Any pointers appreciated....

Thanks,

Paul

*************************************************************************
* Paul J. Wagner / Assistant Professor of Computer Science              *
* Department of Mathematics, Statistics, and Computer Science           *
* Harvey Hall, Room 202J; 715-232-5001                                  *
* University of Wisconsin - Stout     work   - wagnerp@uwstout.edu      *
* Menomonie, WI 54751                 school - wagner@cs.umn.edu        *
*         www - http://www.mscs.uwstout.edu/~paul/home.html             *
*************************************************************************

Re: [INTERFACES] documentation on using PostODBC?

From
"Julia A.Case"
Date:
Quoting WAGNERP@UWSTOUT.EDU (WAGNERP@UWSTOUT.EDU):
> Is there user documentation on how to *use* PostODBC, specifically on how to
> access a PostreSQL database from MS Access?  I've got PostODBC itself
> downloaded/installed, and have set up a PostgreSQL data source, but am not
> sure what needs to be done to allow MS Access to connect to and manipulate
> this data source.  Any pointers appreciated....
>
    If you already have the datasource setup in ODBC...
    Go into access and create a new table, but select "Link" from the
list of options.  Then tell it to use ODBC as the datasource and select
the one that links to your Database.

    This will then give you a list of the tables in your database and
you can link the ones you like...  Make sure to specify the primary keys
for access so that you can update the table.

    If you need more help please feel free to email me.

Julie

--
[  Julia Anne Case  ] [        Ships are safe inside the harbor,       ]
[Programmer at large] [      but is that what ships are really for.    ]
[   Admining Linux  ] [           To thine own self be true.           ]
[ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]

Re: [INTERFACES] documentation on using PostODBC?

From
William Woods
Date:
Please get me off this list........



William Woods - wwoods@cybcon.com
Caldeal Linux - Kernel 2.0.33
Netscape 4.05 Mail