Skip site navigation (1) Skip section navigation (2)

RE: Wierd ODBC access issue

From: radius <radius(at)codegrinder(dot)com>
To: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: Wierd ODBC access issue
Date: 2001-05-29 12:11:45
Message-ID: Pine.BSO.4.33.0105290711230.15788-100000@codegrinder.com (view raw or flat)
Thread:
Lists: pgsql-odbc
is there anyway to be able to alter table design from within access?
thanks..

-jason

On Tue, 29 May 2001, Henshall, Stuart - WCP wrote:

> Hello,
> 	You can't alter table design from access using linked tables, if
> thats what you meant by not being able to update columns. You say you can
> only add/update/delete records, if you can't read them this could be a user
> permissions thing on PG.
> 	If you're co-worker is going through ODBC then it's possible s/he
> has still has the read only option checked (there's the driver and data
> source to uncheck). It could also be user permissions on PG (theres select,
> update/delete, and insert rights). I've found PGAdmin handy as a windows gui
> for PG
> (http://www.greatbridge.org/project/pgadmin/projdisplay.php )
> - Stuart
>
> > -----Original Message-----
> > From:	radius [SMTP:radius(at)codegrinder(dot)com]
> > Sent:	Friday, May 25, 2001 5:31 PM
> > To:	pgsql-odbc(at)postgresql(dot)org
> > Subject:	Wierd ODBC access issue
> >
> >
> > i've got an odd situation to where i can connect w/ access via odbc to my
> > database .. but I can only add/update/delete records . not columns..
> >
> > a coworker at a remote location can only read the table?
> >
> > are there any permissions on the pgsql side that govern this?
> >
> > if anyone could give a suggestion of what to look at i'd appreciate it
> > alot.. thanks.. cause i have no clue..
> >
> > -jason
> >
>


In response to

pgsql-odbc by date

Next:From: radiusDate: 2001-05-29 12:24:36
Subject: Re: access question
Previous:From: Henshall, Stuart - WCPDate: 2001-05-29 08:12:00
Subject: RE: Wierd ODBC access issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group