Strange Access and PgSQL ODBC

Поиск
Список
Период
Сортировка
Искать

Strange Access and PgSQL ODBC

От:
Charles Killmer <charlesk@netgaintechnology.com>
Дата:
 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.  I figured out how to repeat it but still have no idea how to fix it.  Whenever I eneter a value that is already in the table it does this.  If you have a field called firstName and Chuck is already in there, enetering Chuck again will cause this.  If anyone can help I would really appreciate it.

Thanks 
Charles Killmer

Re: Strange Access and PgSQL ODBC

От:
Jamie Walker <jamie@sagaxis.co.uk>
Дата:
In article <01C03744.C1ACB940@CHARLES>, Charles Killmer  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."
FAQ