Hi all, Wondering if you can help. We have a PostgreSQL database that we are using to store our data and we are using Access as the front-end. I have linked all the tables and up to now have had no problem with creating the forms/queries based on this data. Until now that is. One of the tables which has around 27 million records (addresses), if I query it using one Postcode (not unique but indexed), it works fine and brings back the records. However if I join it to a local table containing a list of addresses, and link it on the postcode, I get the error "ODBC- call failed. Bindings were not allocated properly. (#15)" Then if I try the same query that worked previously (or any other query on any other table), I get this same error and the only way I can get round it is by re-linking all the tables and closing and re- opening the database. I have no clue what this means and google is not helping much either. Has anyone got any advice? Many thanks in advance leddy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
