Thread: Strange Access and PgSQL ODBC

Strange Access and PgSQL ODBC

From
Charles Killmer
Date:
A while ago I posted a message about stange deletions in a linked table.  When a value would be entered into the table
throughaccess (table or form view), it would change all the values on that row to #Deleted, until the table was closed
andreopend.  I figured out how to repeat it but still have no idea how to fix it.  Whenever I eneter a value that is
alreadyin the table it does this.  If you have a field called firstName and Chuck is already in there, enetering Chuck
againwill cause this.  If anyone can help I would really appreciate it.
 

Thanks 
Charles Killmer


Re: Strange Access and PgSQL ODBC

From
Jamie Walker
Date:
In article <01C03744.C1ACB940@CHARLES>, Charles Killmer <charlesk@netgai
ntechnology.com> writes
> A while ago I posted a message about stange deletions in a linked table.  When 
>a value would be entered into the table through access (table or form view), it 
>would change all the values on that row to #Deleted, until the table was closed 
>and reopend.
Turn ROW VERSIONING on in the advanced properties for the ODBC
connection and re-attach the tables. Make sure that the tables have a
primary key and it should work fine. (NB you will see an extra column
called 'xmin' in each table. You can ignore it.)

HTH,
-- 
Jamie Walker              "While there are no known bugs in it, it might 
jamie@sagaxis.co.uk        destroy your filesystems, eat your data and
http://www.sagaxis.co.uk/  start World War III. You have been warned."