Thread: MSACCESS and geometric field corruption

MSACCESS and geometric field corruption

From
"Servizio Informatico - Comune di Porcia"
Date:
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.
 

Re: MSACCESS and geometric field corruption

From
Mike Toews
Date:
On 19 August 2010 07:46, Servizio Informatico - Comune di Porcia
<info@comune.porcia.pn.it> wrote:
> Can I keep hidden or locked only geometry fields for all tables that 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