X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 157929DCC33 for ; Thu, 1 Dec 2005 11:41:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43354-09 for ; Thu, 1 Dec 2005 11:41:36 -0400 (AST) X-Greylist: delayed 00:06:39.175562 by SQLgrey- Received: from qsmtp3.mc.surewest.net (qsmtp.mc.surewest.net [66.60.130.145]) by postgresql.org (Postfix) with SMTP id 925069DD685 for ; Thu, 1 Dec 2005 11:41:38 -0400 (AST) Received: (qmail 24610 invoked from network); 1 Dec 2005 07:34:16 -0800 Received: by simscan 1.1.0 ppid: 24595, pid: 24596, t: 2.5213s scanners: regex: 1.1.0 attach: 1.1.0 clamav: 0.84/m:34/d:1198 spam: 3.0.3 Received: from unknown (HELO chris) (65.78.162.90) by qsmtp3 with SMTP; 1 Dec 2005 07:34:13 -0800 From: "Chris Moore" To: Subject: Data showing up as #Deleted in Access Date: Thu, 1 Dec 2005 07:35:00 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcX2d+Jo9sO24IrhSeKrKUrBA6chDQAFAnFQ In-Reply-To: <20051201130406.GA13995@soptik.pzkagis.cz> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-Id: <20051201154138.925069DD685@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.927 required=5 tests=[MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.927 X-Spam-Level: X-Archive-Number: 200512/2 X-Sequence-Number: 6481 I'm trying to get ODBC working for the first time so that I can access a Postgres database from Access. I'm running PostgrSQL 8.0.3, PostgreSQL ODBC 8.01.01.01, and Access 2003 version 11.6355.6360 SP1. The database is on a system running RedHat Linux 2.6.9-6.37-EL and the client is running Windows XP SP2. When I try to open the ODBC data source in Access I see the list of tables correctly. If I pick one of the tables and open it I get the correct field names and the correct number of rows, but every field in every row says "#Deleted" instead of having data. Can anyone suggest what might be wrong? Thanks, Chris