Date: Fri, 6 Oct 2000 16:38:37 -0500
Message-Id: <200010062138.QAA03185@proxy.hddesign.com>
To: pgsql-interfaces@postgresql.org
From: David Huttleston Jr <dhjr@hddesign.com>
Reply-To: dhjr@hddesign.com
Subject: Re: Access and PGSQL
In-Reply-To: <003701c02fca$a63711a0$330a0a0a@6014cwpza006>

Get used to deleting and recreating those ODBC links.  We
found out that a ODBC link is static once it's created.  For
example if you add a column in PG it will not appear in 
Access.  Delete and recreate the link-- then you will see it.
Have Fun,
	Dave

On Fri, 6 Oct 2000 15:21:38 -0400, you wrote:
> Oh, wait.. I see... After I took off the check box, I had to relink it... I
> couldn't just take of the check box and try to open it again.
> 
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> ----- Original Message -----
> From: "Clark, Joel" <jclark@lendingtree.com>
> To: "'Adam Lang'" <aalang@rutgersinsurance.com>;
> <pgsql-interfaces@postgresql.org>
> Sent: Friday, October 06, 2000 3:14 PM
> Subject: RE: [INTERFACES] Access and PGSQL
> 
> 
> > > If I create the DSN for the ODBC driver through the control Panel I can
> > not
> > > update rows.  If I create it through Access97 (by choosing ODBC and NEW
> > > machine source) I can?
> >
> > It's been a while since I have done this, but I think the ODBC driver
> > defaults to read-only.  Look around, I know there was a checkbox
> > somewhere......
> >
> > Joel
> 
>