Re: ODBC & Access [Try 2]

If you send the table definition I will see if I can get it to work here.
- Stuart

-----Original Message-----
From: David Olbersen [mailto:DOlbersen(at)stbernard(dot)com]
Sent: 25 April 2003 16:09
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] ODBC & Access [Try 2]

Stuart,

Row versioning didn't make any difference.

Looking to Microsoft for help (ugh) I found this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;128809
<http://support.microsoft.com/default.aspx?scid=kb;en-us;128809>

Which didn't really help that much. It seems to say the problem is with
Access 2.0 or 97 or some such. But I'm using Access 2000!

I may just have to give up on this one and find some other way of doing
this.

_____

David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152

-----Original Message-----
From: Henshall, Stuart - Design & Print
[mailto:SHenshall(at)westcountry-design-print(dot)co(dot)uk]
Sent: Friday, April 25, 2003 7:40 AM
To: David Olbersen
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: RE: [ODBC] ODBC & Access [Try 2]

Try enabling row versioning.
IIRC there's more on http://techdocs.postgresql.org
<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
<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
<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.

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.