| From: | Peter Pilsl <pilsl(at)goldfisch(dot)at> |
|---|---|
| To: | postgres mailinglist <pgsql-general(at)postgresql(dot)org> |
| Subject: | cant alter/create tables via odbc |
| Date: | 2001-11-19 17:37:24 |
| Message-ID: | 20011119183723.A68434@i3.atat.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)goldfisch(dot)at
sms : pilsl(at)max(dot)mail(dot)at
pgp-key available
| From | Date | Subject | |
|---|---|---|---|
| Next Message | F Harvell | 2001-11-19 18:00:11 | Re: [HACKERS] bug or change in functionality in 7.2? |
| Previous Message | Stephan Szabo | 2001-11-19 17:29:21 | Re: nested select query take too long |