Thread: alter tables from ms-access

Can I alter tables from ms-access via postgres-odbc ? Just now I can
alter the content (insert,update,delete), but not the structure (add
columns ..).  When I want to change properties of an linked table
ms-access warns me : 'cant change properties on linked tables'.  Is
this a ms-problem, a odbc-problem, a postgres-problem ?

I can create new tables by exporting them into the odbc-datasource.

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

Peter Pilsl wrote:
>
> Can I alter tables from ms-access via postgres-odbc ? Just now I can
> alter the content (insert,update,delete), but not the structure (add
> columns ..).  When I want to change properties of an linked table
> ms-access warns me : 'cant change properties on linked tables'.  Is
> this a ms-problem, a odbc-problem, a postgres-problem ?

It seems a ms-access problem.

regards,
Hiroshi Inoue