MSACCESS and geometric field corruption

MSACCESS and geometric field corruption

am 19.08.2010 16:46:08 von Servizio Informatico - Comune di Porcia

This is a multi-part message in MIME format.

------=_NextPart_000_0015_01CB3FBE.062930D0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I connect postgres/postgis tables into my msacces database, and i want to
edit, delete or add records.
Geometry fields ("the_geom") are visible as memo type and are editable (with
consequent corruption of data).
Can I keep hidden or locked only geometry fields for all tables that i
connect (or reconnect) on my database?

Thanks for all suggestion.


------=_NextPart_000_0015_01CB3FBE.062930D0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">


I =
connect=20
postgres/postgis tables into my msacces database, and i want to =
edit,=20
delete or add records. 

size=3D2>Geometry fields=20
("the_geom") are visible as memo type and are editable (with =
consequent=20
corruption of data).

Can I =
keep hidden or=20
locked only geometry fields for all tables that i connect (or=20
reconnect) on my database? 

size=3D2> 

Thanks =
for all=20
suggestion.

size=3D2> 


------=_NextPart_000_0015_01CB3FBE.062930D0--

Re: MSACCESS and geometric field corruption

am 19.08.2010 17:34:06 von Mike Toews

On 19 August 2010 07:46, Servizio Informatico - Comune di Porcia
wrote:
> Can I keep hidden or locked=A0only geometry fields for all tables=A0that i
> connect (or reconnect) on my database?

You can "hide" this in MS Access. Open the table and right-click
the_geom header and choose "Hide Columns". You could also build a Form
for the table in question and either omit the_geom field or set the
property to read-only.

-Mike

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc