Thread: Access and PGSQL

Access and PGSQL

From
"Adam Lang"
Date:
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?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company



RE: Access and PGSQL

From
"Clark, Joel"
Date:
> 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


Re: Access and PGSQL

From
"Adam Lang"
Date:
Yeah, I clear both check boxes... didn't make a difference.

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



Re: Access and PGSQL

From
"Adam Lang"
Date:
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



Re: Access and PGSQL

From
David Huttleston Jr
Date:
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
> 
> 


Re: Access and PGSQL

From
Cedar Cox
Date:
I found one vague mention of relinking tables in the Access 'Building
Applications' book, p.635.  Take a look in the 'Developer Solutions'
database.  This is supplied with Access 97 but I don't think it's
installed by default so you may have to install it.  It also used the
northwind.mdb database, which contains the tables it links to.  

In 'Developer Solutions', look (at the bottom I think) for 'Link tables at
startup'.  There's some VB code for relinking tables.  We adapted this
code for relinking to PGSQL via ODBC.  This code is meant to relink tables
when the northwind database can't be found.  You'll probably just want to
study the code to figure out how it works, then write your own code.  In
your case you'll probably just want to relink everything at startup
regardless, or perhaps just have a 'relink' button on your main form.

Hope this helps..

-Cedar


On Fri, 6 Oct 2000, David Huttleston Jr wrote:
> 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