From: Chris Moore <chrismoore@surewest.net>
To: pgsql-odbc@postgresql.org
Subject: Data showing up as #Deleted in Access
Date: Thu, 1 Dec 2005 07:35:00 -0800
Message-ID: <20051201154138.925069DD685@postgresql.org> (raw)
In-Reply-To: <20051201130406.GA13995@soptik.pzkagis.cz>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: chrismoore@surewest.net, pgsql-odbc@postgresql.org
Subject: Re: Data showing up as #Deleted in Access
In-Reply-To: <20051201154138.925069DD685@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox