From: Joel Burton <jburton@scw.org>
To: Scott Teglasi <scotty@mediaglue.net>
Cc: pgsql-general@postgresql.org
Cc: Pgsql-interfaces@postgresql.org
Subject: Re: RE: Using Postgres with Access 2000
Date: Fri, 5 Jan 2001 13:55:41 -0500
Message-ID: <200101051855.f05Ith625669@olympus.scw.org> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jburton@scw.org, scotty@mediaglue.net, pgsql-general@postgresql.org
Subject: Re: RE: Using Postgres with Access 2000
In-Reply-To: <200101051855.f05Ith625669@olympus.scw.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox