Re: ODBC & Access [Try 2] - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: ODBC & Access [Try 2]
Date
Msg-id 20030424190754.44922.qmail@web20801.mail.yahoo.com
Whole thread Raw
In response to ODBC & Access [Try 2]  ("David Olbersen" <DOlbersen@stbernard.com>)
List pgsql-general
--- David Olbersen <DOlbersen@stbernard.com> wrote:
> I'm trying to use Access as a front end for
> Postgres. This is
> mainly for data-entry and manual updates.
>
> I was able to establish an ODBC connection to the
> server
> without any problems. I was also able to link the
> tables that
> I need. I linked 8 tables total.
>
> 7 of them work just fine and I can see all the data
> in them.
> The last one though, only displays '#DELETED' for
> each column
> of each row. I checked the permissions on all the
> tables and
> they're the same -- I have read access (all I need
> for now, right?)
>
> Any idea what's going on? This is PostgreSQL 7.3.2
> on FreeBSD with the PostgreSQL ODBC driver version
> 7.02.00.05 on Win XP.

<guess>
Make sure driver option "row versioning" is checked.
Also, make sure that the offending table has a primary
key that Access is recognizing as such.
</guess>
If both of those conditions are met, and you still
have a problem, please post your driver settings.

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: [SQL] rewriting values with before trigger
Next
From: ahoward
Date:
Subject: has_table_priviledge