Обсуждение: question about MS Access connect to Postgresql 6.5.2-1

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.

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.
>
>
>

"Micheal H." <mr_hopkins@earthlink.net> wrote in message
news:38782bb0.1232288@news.earthlink.net...
> I found the read only option, unchecked it and still have the problem
> updating or adding records...Postgresql-6.3.2 and Access97

It's working fine to me now. The one of the drawback of
creating database in Access97 and upsize (right term? ) to
postgres will remove your primary for some unknown
reason. So, my best bet is creating those tables by using
postgres and then link the table over. This works for me.

Anyone are using PhP for Windows for the web scripting
tools?

Kevin.