pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess and PGSQL
6+ messages / 4 participants
[nested] [flat]
* Access and PGSQL
@ 2000-10-06 19:03 Adam Lang <aalang@rutgersinsurance.com>
0 siblings, 0 replies; 6+ messages in thread
From: Adam Lang @ 2000-10-06 19:03 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: Access and PGSQL
@ 2000-10-06 19:14 Clark, Joel <jclark@lendingtree.com>
2000-10-06 19:19 ` Re: Access and PGSQL Adam Lang <aalang@rutgersinsurance.com>
2000-10-06 19:21 ` Re: Access and PGSQL Adam Lang <aalang@rutgersinsurance.com>
0 siblings, 2 replies; 6+ messages in thread
From: Clark, Joel @ 2000-10-06 19:14 UTC (permalink / raw)
To: 'Adam Lang' <aalang@rutgersinsurance.com>; pgsql-interfaces
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Access and PGSQL
2000-10-06 19:14 RE: Access and PGSQL Clark, Joel <jclark@lendingtree.com>
@ 2000-10-06 19:19 ` Adam Lang <aalang@rutgersinsurance.com>
1 sibling, 0 replies; 6+ messages in thread
From: Adam Lang @ 2000-10-06 19:19 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Access and PGSQL
2000-10-06 19:14 RE: Access and PGSQL Clark, Joel <jclark@lendingtree.com>
@ 2000-10-06 19:21 ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-06 21:38 ` Re: Access and PGSQL David Huttleston Jr <dhjr@hddesign.com>
1 sibling, 1 reply; 6+ messages in thread
From: Adam Lang @ 2000-10-06 19:21 UTC (permalink / raw)
To: Clark, Joel <jclark@lendingtree.com>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Access and PGSQL
2000-10-06 19:14 RE: Access and PGSQL Clark, Joel <jclark@lendingtree.com>
2000-10-06 19:21 ` Re: Access and PGSQL Adam Lang <aalang@rutgersinsurance.com>
@ 2000-10-06 21:38 ` David Huttleston Jr <dhjr@hddesign.com>
2000-10-07 14:43 ` Re: Access and PGSQL Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 1 reply; 6+ messages in thread
From: David Huttleston Jr @ 2000-10-06 21:38 UTC (permalink / raw)
To: pgsql-interfaces
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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Access and PGSQL
2000-10-06 19:14 RE: Access and PGSQL Clark, Joel <jclark@lendingtree.com>
2000-10-06 19:21 ` Re: Access and PGSQL Adam Lang <aalang@rutgersinsurance.com>
2000-10-06 21:38 ` Re: Access and PGSQL David Huttleston Jr <dhjr@hddesign.com>
@ 2000-10-07 14:43 ` Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 0 replies; 6+ messages in thread
From: Cedar Cox @ 2000-10-07 14:43 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2000-10-07 14:43 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-06 19:03 Access and PGSQL Adam Lang <aalang@rutgersinsurance.com>
2000-10-06 19:14 RE: Access and PGSQL Clark, Joel <jclark@lendingtree.com>
2000-10-06 19:19 ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-06 19:21 ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-06 21:38 ` David Huttleston Jr <dhjr@hddesign.com>
2000-10-07 14:43 ` Cedar Cox <cedarc@visionforisrael.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox