There are is a Read-Only option in postgresODBC driver properties... checked
by default :-]
I have seen it in Advanced Options form of Connection dialog during creation
of new data source
in MS Query.
I hope it will help you a little bit.
Dmitry
"Kevin Lam" <kamanl@earthlink.com> wrote in message
news:o5e94.3459$GF1.189168@newsread1.prod.itd.earthlink.net...
> I'm using access to connect to the PostgreSQL server running on a linux
thru
> postgresODBC driver.
>
> I can link the table and can read the data in the table but
> I can't update it?! I can not add a record. What am I
> doing wrong?
>
> The user login has only the create db privilege and without
> the superuser privilege.
>
> Please help!
>
> Kevin.
>
>
>