Message-Id: <200101051855.f05Ith625669@olympus.scw.org>
From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: Scott Teglasi <scotty@mediaglue.net>
Date: Fri, 5 Jan 2001 13:55:41 -0500
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: RE: Using Postgres with Access 2000
CC: pgsql-general@postgresql.org, Pgsql-interfaces@postgresql.org
In-reply-to: <1F578E8C702AD311B8710080C8D84C11222065@mediaglue.net>

> Let me rephrase my words. :)
> I have created postgresql tables with pgaccess.  I am unable to add
> new records to those tables using Microsoft Access 2000.  How do I
> remedy this situation, and also, is there a way to create tables
> within Microsoft Access 2000 on the Postgresql server.  

Questions about Access + Pg are most appropriate to pgsql-
interfaces, BTW.

By default, ODBC connections to Pg are read-only. Did you turn off 
BOTH read-only option boxes?

You can create tables by using the DDL statement as a 'Pass-
through query' in Access.

More complete answers can be found in the Pg+Access FAQ at 
www.scw.org/pgaccess.

Good luck,

--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)