Access 2000 and PostgreSQL 6.5

Поиск
Список
Период
Сортировка
От Phil Davey
Тема Access 2000 and PostgreSQL 6.5
Дата
Msg-id Pine.SGI.3.96.1000825113737.3963347D-100000@mole.bio.cam.ac.uk
обсуждение исходный текст
Список pgsql-interfaces
Hello,

This is my first post to this list, so I hope it's right.

I'm trying to get Access 2000 to use a database on a linux PostgreSQL box.
The database works fine, as I can use a different program on a different
machine to select and update records etc.

Access (using linked tables) will view the database fine, but it gives a
'write conflict' message whenever I try and update a record.

I've tried making a MSysConf table which made no difference. 
I've unset the readonly tick boxes in the ODBC driver settings.
The pg_hba.conf file is set up correctly.
I've also found some info in the microsoft knowledgebase (Q225926) which
seems to describe the problem exactly, but none of the solutions seem to
work.

What am I missing?

Thanks for any help.
-- 
Phil Davey 
http://www.pod-designs.net/philandjo.html 
E-mail pod@pod-designs.net                          ICQ 46295740
Just because you're smart, doesn't mean you can't act stupid....



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Cedar Cox
Дата:
Сообщение: Re: JDBC problem
Следующее
От: Manika dey
Дата:
Сообщение: RE: using large objects with jdbc