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
>
