pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

MsAccess and ODBC Postgres: table structure modification
3+ messages / 3 participants
[nested] [flat]

* MsAccess and ODBC Postgres: table structure modification
@ 1999-10-16 12:49  Cristiano Verondini <cverondini@deis.unibo.it>
  0 siblings, 1 reply; 3+ messages in thread

From: Cristiano Verondini @ 1999-10-16 12:49 UTC (permalink / raw)
  To: pgsql-interfaces

Hello,

	is it possible to have MsAccess modify tables from imported ODBC
Postgres database?

	Thanks

		Cris

-- 
Cristiano Verondini
http://www.ing.unibo.it/~cverond



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: [INTERFACES] MsAccess and ODBC Postgres: table structure modification
@ 1999-10-18 14:02  Thomas Byrnes <tbyrnes@helioshealth.com>
  parent: Cristiano Verondini <cverondini@deis.unibo.it>
  0 siblings, 0 replies; 3+ messages in thread

From: Thomas Byrnes @ 1999-10-18 14:02 UTC (permalink / raw)
  To: 'Cristiano Verondini' <cverondini@deis.unibo.it>; pgsql-interfaces

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

************




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: [INTERFACES] MsAccess and ODBC Postgres: table structure modi fication
@ 1999-10-18 14:22  Ansley, Michael <Michael.Ansley@intec.co.za>
  0 siblings, 0 replies; 3+ messages in thread

From: Ansley, Michael @ 1999-10-18 14:22 UTC (permalink / raw)
  To: 'tbyrnes@helioshealth.com' <tbyrnes@helioshealth.com>; 'Cristiano Verondini' <cverondini@deis.unibo.it>; pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~1999-10-18 14:22 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-16 12:49 MsAccess and ODBC Postgres: table structure modification Cristiano Verondini <cverondini@deis.unibo.it>
1999-10-18 14:02 ` Thomas Byrnes <tbyrnes@helioshealth.com>
1999-10-18 14:22 RE: [INTERFACES] MsAccess and ODBC Postgres: table structure modi fication Ansley, Michael <Michael.Ansley@intec.co.za>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox