Re: ODBC & Access [Try 2]

Try enabling row versioning.
IIRC there's more on http://techdocs.postgresql.org about linking access and
some of the problems with like rounding or text/memo.
hth,
- Stuart
P.S. Sorry about the discalimer adder messing with the format :(

> -----Original Message-----
> From: David Olbersen [mailto:DOlbersen(at)stbernard(dot)com]
>
> 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.
>
> I've also tried the snapshot driver version: 7.03.00.01 with
> now change. I've also disabled the 'updateable cursors'
> option for the DSN.
>
> Any suggestions are more than welcome.
>
> --------------------------
> David Olbersen
> iGuard Engineer
> 11415 West Bernardo Court
> San Diego, CA 92127
> 1-858-676-2277 x2152
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

DISCLAIMER:The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.