#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Location
    Dalec HI
    Posts
    26
    Rep Power
    0

    Question 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
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    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?
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Location
    Dalec HI
    Posts
    26
    Rep Power
    0
    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
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    1
    Rep Power
    0
    in the odbc options for your datasource, under 'driver' and 'datasource', are the read-only boxes checked?

IMN logo majestic logo threadwatch logo seochat tools logo