On Sat, 26 May 2001, radius wrote:
> i was wondering if you could shed some light here.. since i;m not getting
> much from the newsgroups.. i have postgres + odbc installed and with
> pgadmin ( uses odbc ) i can do whatever i want.. but with access i can
> only view.. i can't add columns or rows.. any ideas?
You'll need to be more specific w/your info to the newsgroups.
Can't add fields through Access? You can't normally, unless you do this
as a Pass-Through query with the DDL statement to add a column.
Your best bet is to skip this, just add the column in psql, then
delete the linked table in Access and relink (you can use the Linked
table manager in Access to make relinking much easier)
Can't add rows? No idea w/out more info. Do you have permission to do
so? Can you change existing rows? What happens when you try to add them.
Followups to the newsgroups, only, please.
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington