Re: ODBC read/write permission in MS Access - Mailing list pgsql-general

From Joel Burton
Subject Re: ODBC read/write permission in MS Access
Date
Msg-id Pine.LNX.4.21.0107311043020.30379-100000@olympus.scw.org
Whole thread Raw
In response to ODBC read/write permission in MS Access  (Jason Turner <jasont@indigoindustrial.co.nz>)
List pgsql-general
On Tue, 31 Jul 2001, Jason Turner wrote:

> Not sure if this should be here or in the ODBC list (that one
> looked more developer-ish, wheras this list seems more admin-ish.
> anyway....)
>
> Testbedding an MS Access client to a PostgreSQL database, running
> v 7.1.2 postgreSQL, Access 2000 on a Windows 2000 box.  Got the driver,
> version 7.1.0006.  Worked like a treat, *except* for trying change
> records on the Access end.  The table is linked in Access via
> "File->Get External Data->Link Tables".  Not sure what I did wrong.
> When I set up the DSN, I checked the options "Driver->Read Only"
> (unchecked) and "Data Source->Read Only" (unchecked).
> What did I miss?

What exact error message are you getting?

Have you looked at the PostgreSQL + Access FAQ at odbc.postgresql.org?

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington


pgsql-general by date:

Previous
From: Mike Finn
Date:
Subject: Re: Getting Primary & Foreign Key Information?
Next
From: Tom Lane
Date:
Subject: Re: Sequences and inheritance