RE: Wierd ODBC access issue

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
>