Thread: RE: [INTERFACES] MsAccess and ODBC Postgres: table structure modi fication

RE: [INTERFACES] MsAccess and ODBC Postgres: table structure modi fication

From
"Ansley, Michael"
Date:
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
>> 
>> ************
>> 
>> 
>> ************
>>