Re: [HACKERS] RE: [INTERFACES] error message

  <p>JT Kirkpatrick ha scritto: <blockquote type="CITE">i do have a few fields (combo boxes based on a query) that
sortedon a <br />calculated field -- but they seem to work fine in other forms.  --don't <br />think that was it.  but,
basedon your postulations i re-did a few of the <br />queries to NOT sort on the calculated fields.  still bombed
though.. . <br /> so, i deleted the link to the particular table, and then re-linked to it, <br />and to my surprise, i
cannow pull up the form without it bombing.  i can <br />even zip through all the records (36k of them) if i wish.  but
nowit still <br />has a problem -- the recordset is not updateable.  if i open the table <br />directly (not through
anyquery, and again, from within access97, pgsql <br />6.4.2), the table itself is not updateable.  the table DOES have
aprimary <br />key -- a DUAL FIELD primary key.  I found over the last few weeks that <br />Access97 will treat any
ODBCtable without a primary key defined as not <br />updateable, but will it also do the same for DUAL FIELD primary
keyODBC <br />tables??  it appears so, but can anyone confirm it??</blockquote> I'm using also access97 with postodbc
6.40.0005and PostgreSQL v6.5beta1 and it works fine and I have primary <br />keys like:<tt></tt><p><tt>Table    =
figure_pkey</tt><br/><tt>+----------------------------------+----------------------------------+-------+</tt><br
/><tt>|             Field               |              Type                | Length|</tt><br
/><tt>+----------------------------------+----------------------------------+-------+</tt><br/><tt>|
azienda                         | char()                           |    16 |</tt><br /><tt>|
tipo                            | char()                           |     2 |</tt><br /><tt>|
gruppo                          | int4                             |     4 |</tt><br /><tt>|
inizio_attivita                 | date                             |     4 |</tt><br
/><tt>+----------------------------------+----------------------------------+-------+</tt><p>Whichversion of psqlodbc
areyou using? <br />I know that Access uses dynaset or snapshots to connect to database. <br />- If you attach a table
withoutdefine a primary key Access connects to the table as snapshot and you can't write table. <br />- If you define a
primarykey then Access connects to the table as dynaset and you are able to write table. <br />- You must define
primarykey during table linkage time. <br />- If you have the ODBC manager option RECOGNIZE UNIQUE INDEXES checked then
youdon't need define it <br />  because Access recognize the primary key automatically. <br />- If you have the ODBC
manageroption READ ONLY checked then all linked tables are read only. <br />-- <br
/>______________________________________________________________<br />PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled
bygcc 2.7.2.3 <br />^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ <br />Jose' <br />