Hello.
I have an MS - Access front end which connects to PostgreSQL 8.1.3.
Almost everything is working great, I especially love how I can use
rules in PostgreSQL to be able to update and insert into views, which
is awesome.
Now my only issue, and I'm not sure this is even possible but here it
is. Can one base an MS Access form on a PostgreSQL table using only
AD and have it be updateable and insertable? Currently all I'm able
to do is get the data as READNLY when I do it via AD, yet when I use
linked tables in MS Access I am able to update and insert. Here is the
AD code:
Sub F ( Cancel As Integer)
Dim cn As ADDB.Connection
Dim rs AS ADDB.RecordSet
Set cn = New ADDB.Connection
Set rs = New ADDB.RecordSet
"DSN=PostgreSQL ANSI; Database=db; UID=postgres;
Password=xxxx;"
rs.CursorLocation = adUseServer
"SELECT * FRM view_x;", cn, KeySet, adL
Set Me.Recordset = rs
End Sub
The above returns records to the form, its just that they are not
updateable or insertable. Thanks for your help.
(end of broadcast)
TIP 5: don't forget to increase your free space map settings

"Karen Hill" <karen_hill22 (AT) yahoo (DOT) comwrites:
Can one base an MS Access form on a PostgreSQL table using only
AD and have it be updateable and insertable?

Damifino, but the people who would know probably hang out in pgsql-odbc,
not here

regards, tom lane

(end of broadcast)
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly