Thread: cant alter/create tables via odbc
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
The ro-flag is unchecked and there is nothing in the logfile that would me help to understand my problem. Even before I attempt to alter a tables structure (add new column or whatever) ms-access tells me that I cant do this with linked tables. In the meantime - after a useful hint per email - I got the information that I can create new tables via odbc when I create them in ms-access first and then export it to odbc ... however - if there is a odbc-mailinglist I should use it and tell my sorrows there :) thnx, peter On Mon, Nov 19, 2001 at 01:04:55PM -0500, Ryan C. Bonham wrote: > > The ODBC Driver has a "readonly" option, it is located under the DataSource button on the ODBC screen. Is it unchecked? > If that is unchecked let me know, i will try and comeup with a better awnser.. You can turn on ODBC logging under teh Driveroptions, and then email me that file, if it still doesn't work. Also you might want to try posting this question tothe ODBC mailing list pgsql-odbc@postgresql.org. > > > Ryan Bonham > -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: pilsl@goldfisch.at sms : pilsl@max.mail.at pgp-key available
Hello Peter, Peter Pilsl schreef: > not sure if this is the right place to ask, cause I dont know if my > problems are postgres-related or ms-access-related. defenitely MS-Access > I want give some privilieged users give direct access to some > postgresql-databases via a ms-access-frontend. > I'm not able > to alter or create tables in the database. I just got the error: > "access cant do changes on linked tables". Access just links to your table. In a way it is "able to use" your table. Not more. You cannot alter the table-design through Access. That is quite logical, because table design allways is something propretary for every database. Datatypes can be different... etc. I do have 2 tips: 1. You _can_ export a table from Access to postgresql. So if you want to create a new table, you can design it as a local Access-table and then export the (empty) table into postgresql. It's a *rough* export though.... as I remember... no indexes are created and primary-keys aren't defined. 2. Use the Win32 admin-tool. I can't remember it's name but it's there on the net somewhere... and it gives users a nice graphical interface to the db. Arian. > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org