Re: Read-only in MSAccess

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

Re: Read-only in MSAccess

От:
Ben Gunter <bgunter@alef.gcsu.edu>
Дата:
(Original message was lost.  Oops.)

I was fiddling around with Access and the ODBC driver this morning and
discovered that Access will not allow you update ODBC sources unless you pick
at least one field (up to ten) as a unique index.  Otherwise, it's read-only.

Hope this helps.

-Ben

Re: [INTERFACES] Re: Read-only in MSAccess

От:
"Ross J. Reedstrom" <reedstrm@rice.edu>
Дата:
I've noticed this affect. Has anyone run traces of the connection, to
see if Access tries to determine the primary key from the backend? Does
this requirement go away if you (manually) set the 'relhaspkey' bool in
pg_class for the table?  I'd do all this testing myself, but my NT test
box got taken away (yeay! boo! I'm so conflicted...)

Ross

Ben Gunter wrote:
> 
> (Original message was lost.  Oops.)
> 
> I was fiddling around with Access and the ODBC driver this morning and
> discovered that Access will not allow you update ODBC sources unless you pick
> at least one field (up to ten) as a unique index.  Otherwise, it's read-only.
> 
> Hope this helps.
> 
> -Ben

-- 
Ross J. Reedstrom, Ph.D.,  
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005
FAQ