Thread: 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? Adam Lang Systems Engineer Rutgers Casualty Insurance Company
> 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
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
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
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 > >
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