Re: ODBC & Access [Try 2]

--- David Olbersen <DOlbersen(at)stbernard(dot)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