The data structure of linked tables in Access is read-only. You can query,
modify, and add data to a linked table, but that is all. And you can only
modify if a primary key has been identified by Access, or specified by you
on request from Access when you link the table.
If you need to modify the structure of a table, you have to use the native
tools, or something like ERWin, and then delete and re-link the table in
Access.
MikeA
>> -----Original Message-----
>> From: Thomas Byrnes [mailto:tbyrnes@helioshealth.com]
>> Sent: Monday, October 18, 1999 4:03 PM
>> To: 'Cristiano Verondini'; pgsql-interfaces@postgreSQL.org
>> Subject: RE: [INTERFACES] MsAccess and ODBC Postgres: table structure
>> modification
>>
>>
>> Cris,
>> Do you mean imported or linked? If you import the
>> tables they become Access
>> tables and can be completely modified, but if they are
>> linked all I have
>> been able to do is add and remove data... so I too am
>> wondering if this is
>> possible.
>>
>> Regards,
>>
>> Tom
>>
>> -----Original Message-----
>> From: owner-pgsql-interfaces@postgreSQL.org
>> [mailto:owner-pgsql-interfaces@postgreSQL.org] On Behalf Of
>> Cristiano
>> Verondini
>> Sent: Saturday, October 16, 1999 8:50 AM
>> To: pgsql-interfaces@postgreSQL.org
>> Subject: [INTERFACES] MsAccess and ODBC Postgres: table structure
>> modification
>>
>> Hello,
>>
>> is it possible to have MsAccess modify tables from imported ODBC
>> Postgres database?
>>
>> Thanks
>>
>> Cris
>>
>> --
>> Cristiano Verondini
>> http://www.ing.unibo.it/~cverond
>>
>> ************
>>
>>
>> ************
>>
