MSACCESS and geometric field corruption

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.17080" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D236481414-19082010><FONT face=3DArial size=3D2>I =
connect
postgres/postgis tables into my msacces database, and i want to =
edit,
delete or add records. </FONT></SPAN></DIV>
<DIV><SPAN class=3D236481414-19082010><FONT face=3DArial =
size=3D2>Geometry fields
("the_geom") are visible as memo type and are editable (with =
consequent
corruption of data). </FONT></SPAN></DIV>
<DIV><SPAN class=3D236481414-19082010><FONT face=3DArial size=3D2>Can I =
keep hidden or
locked only geometry fields for all tables that i connect (or
reconnect) on my database? </FONT></SPAN></DIV>
<DIV><SPAN class=3D236481414-19082010><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D236481414-19082010><FONT face=3DArial size=3D2>Thanks =
for all
suggestion.</FONT></SPAN></DIV>
<DIV><SPAN class=3D236481414-19082010><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV></BODY></HTML>

------=_NextPart_000_0015_01CB3FBE.062930D0--
Servizio Informatico [ Do, 19 August 2010 16:46 ] [ ID #2046320 ]

Re: MSACCESS and geometric field corruption

On 19 August 2010 07:46, Servizio Informatico - Comune di Porcia
<info [at] comune.porcia.pn.it> 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

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Mike Toews [ Do, 19 August 2010 17:34 ] [ ID #2046321 ]
Datenbanken » gmane.comp.db.postgresql.odbc » MSACCESS and geometric field corruption

Vorheriges Thema: pgsqlodbc utf8 windows?
Nächstes Thema: MS Access and field-level permissions?