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@codegrinder.com]
> > Sent: Friday, May 25, 2001 5:31 PM
> > To: pgsql-odbc@postgresql.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
> >
>
