cant alter/create tables via odbc - Mailing list pgsql-general

From Peter Pilsl
Subject cant alter/create tables via odbc
Date
Msg-id 20011119183723.A68434@i3.atat.at
Whole thread Raw
List pgsql-general
not sure if this is the right place to ask, cause I dont know if my
problems are postgres-related or ms-access-related.

I want give some privilieged users give direct access to some
postgresql-databases via a ms-access-frontend.  I installed the
odbc-driver on win2000 and configured it without any problem.  I also
can access and change the content of existing tables, but I'm not able
to alter or create tables in the database. I just got the error:
"access cant do changes on linked tables".

This is how I do it: I create a ms-access-database (mdb-file) that
holds all the frontend (reports, masks and all this stuff ...) and
then link some tables from the postgres-odbc-source. When I want to
change this tables (structure, not content) I get the above error. I
dont even know which menues to click to create a new table ..

Do I something wrong on ms-access side ?
Is ms-access  just to stupid ?
does odbc not support alter/create ?

a second question is, that all content in my postgresql-database is
stored unicode and access seems to be unable to handle this, but I'm
sure that this is the wrong place to ask this :)

thnx,
peter

--
mag. peter pilsl

phone: +43 676 3574035
fax  : +43 676 3546512
email: pilsl@goldfisch.at
sms  : pilsl@max.mail.at

pgp-key available

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: nested select query take too long
Next
From: Tom Lane
Date:
Subject: Re: Packages for RH7.2