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 >> >> ************ >> >> >> ************ >>