m$ Access + postgreSQL gives readonly access

I'm trying to connect to postgreSQL database from msAccess, and if I link tables, it works fine. When I try to make conection from the code, using dao3.6, I'll keep getting readonly access.

database is setup ok, since I can connect localy remote and modify records without problems.


I know it's more of an Access question, but can't expect m$ to give me an answer about opensource database
Any suggestions would be really welcome

I don't think it's an Access question. If you are getting read-only access, then it is probably just a question of permissions on the Postgres side.

Is PostgreSQL running on a Unix server on the network, or are you running PostgreSQL locally on windows?

If it is running on a Unix server, what ODBC program are you using, and what options have you set up in your pg_hba.conf file?

postGRE is runing on rh73, and hba is setup fine. I'm using odbc driver provided by postgres, and works, because I can link tables to access, and work with them fine, even do queries and stuff.

But accessing postgress from code (vba) gives a readonly access. It's weird because I used same string as it writes down when linking tables (it's a long sausage)

need to try ado sythax, also

in the odbc options for your datasource, under 'driver' and 'datasource', are the read-only boxes checked?