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
>
>