X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EB124D1EE85 for ; Mon, 3 May 2004 03:24:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 41528-02 for ; Mon, 3 May 2004 03:24:15 -0300 (ADT) Received: from mail.syd.swiftdsl.com.au (mail.syd.swiftdsl.com.au [202.154.83.58]) by svr1.postgresql.org (Postfix) with SMTP id 46D08D1EF0B for ; Mon, 3 May 2004 03:24:12 -0300 (ADT) Received: (qmail 26089 invoked from network); 3 May 2004 06:24:12 -0000 Received: from unknown (HELO auditbureau.org.au) (218.214.34.106) by mail.syd.swiftdsl.com.au with SMTP; 3 May 2004 06:24:12 -0000 Message-ID: <4095E59C.9040904@auditbureau.org.au> Date: Mon, 03 May 2004 16:24:28 +1000 From: Simon Dobie Reply-To: simon@auditbureau.org.au User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7b) Gecko/20040316 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Re: FIXED Problems when using MS Access to display References: <40958AAA.30707@auditbureau.org.au> In-Reply-To: <40958AAA.30707@auditbureau.org.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/10 X-Sequence-Number: 4902 Its ok, i managed to figure it out. the Primary Key was not being updated (i did make it auto update in postgress but it doesnt seem to auto update) so i had to manually change the unique value for the records (which was the same for each one.) cheers! %simon