Dear Friends,
I am here for a problem regarding MS Access and PostgreSQL connection
through ODBC. I have liked my PostgreSQL database tables to MS Access.
When I am going for inserting/updating any data is just displays
#deleted. I also use MySQL (client's choice). Same problem occurs for
MySQL also. But when I set the 'Return matching rows' option from
MyODBC 3.51.12 interface. the problem mostly gets solved. Other things
required are PK (or Unique column), a timestamp etc. I have done all
these for POstgreSQL, but it doen't work. Is there any option as
'Return matching rows' for PGODBC? Or How I can solve this problem?
Please help.
Thanks and Regards.
CPK
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
