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 C8CC3D1EEB2 for ; Sun, 2 May 2004 20:56:52 -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 50244-05 for ; Sun, 2 May 2004 20:56:34 -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 9582AD1EEA9 for ; Sun, 2 May 2004 20:56:29 -0300 (ADT) Received: (qmail 3915 invoked from network); 2 May 2004 23:56:31 -0000 Received: from unknown (HELO auditbureau.org.au) (218.214.34.106) by mail.syd.swiftdsl.com.au with SMTP; 2 May 2004 23:56:31 -0000 Message-ID: <40958AAA.30707@auditbureau.org.au> Date: Mon, 03 May 2004 09:56:26 +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: Problems when using MS Access to display Postgres Data Content-Type: text/plain; charset=us-ascii; 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/9 X-Sequence-Number: 4901 Hi, Im not sure if this is the right mail list, apologies if it is not, and could someone let me know where i could post this question if its not the right place. Basically, i have a small pg database with about 628 records in it. I have these tables linked into an access database so that i can use access forms and reports for people to easily get around in the database. However, i just imported 20 records or so, and when i open up the linked table to check, it seems like the first record was imported 20 times. however, when i open PGAdminIII up and view the data, its fine. I can Run the linked table manager and update linked tables, and i get the right data, but then my table becomes un editable and none of my forms work. Does anyone have any clues for how to fix this?! its driving me insane!! %simon