Skip site navigation (1) Skip section navigation (2)

Re: ODBC read/write permission in MS Access

From: Joel Burton <jburton(at)scw(dot)org>
To: Jason Turner <jasont(at)indigoindustrial(dot)co(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ODBC read/write permission in MS Access
Date: 2001-07-31 14:43:43
Message-ID: Pine.LNX.4.21.0107311043020.30379-100000@olympus.scw.org (view raw or flat)
Thread:
Lists: 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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington


In response to

pgsql-general by date

Next:From: Tom LaneDate: 2001-07-31 14:53:28
Subject: Re: Sequences and inheritance
Previous:From: Mike FinnDate: 2001-07-31 14:41:08
Subject: Re: Getting Primary & Foreign Key Information?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group