> 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)