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(at)earthlink(dot)com> wrote in message
news:o5e94(dot)3459$GF1(dot)189168(at)newsread1(dot)prod(dot)itd(dot)earthlink(dot)net(dot)(dot)(dot)
> 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.
>
>
>