Thread: cant alter/create tables via odbc

cant alter/create tables via odbc

From
Peter Pilsl
Date:
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

Re: cant alter/create tables via odbc

From
Peter Pilsl
Date:
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

Re: cant alter/create tables via odbc

From
Arian Prins
Date:
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