Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2004

    Unhappy Unanswered: Connection problem w/ Access & PostgreSQL server...

    Okay, I've been looking around for quite a while, here and in other forums/websites, and I don't think anyone else has come across this. Which either means it's very easy to solute, or very uncommon...

    So, I have a nice PostgreSQL database consisting of 19 tables and a whole bunch of foreign keys, primary keys etcetera. Now, most of the tables work fine when I 'link-tables' in Access 2003 (which is what my clients want to use) through the ODBC driver, but some of them (5 total) don't work. They report the error "ODBC: Call Failed" when opening and all fields are filled with the text "#Name?".

    The strange thing is is that he does know how many rows the table consists of as it fills himself that way. If I look at my postgreSQL DB through pgAdmin I also see that all data has been entered correctly. When the table is empty he also doesn't report an error.

    There is nothing (as far as I see it) special with the tables that don't work in relation to the ones that do work (apart from that they all have a reference to the table 'customer' but so do other tables that DO work).

    Can someone please help me find a solution? I'm almost sure it's something very simple (I haven't worked with the whole PostgreSQL-thing much yet) which I haven't seen...

    Every suggestion is much appreciated...
    [cross-posted in PostgreSQL-forum]
    Last edited by Niko; 06-06-04 at 12:06.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts