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?