RE: ODBC-Problem

Add a primary key index to the tables that you want to be able to update.
Access relies on the primary key for a lot of things. I recommend you add
a primary key to all postgres tables.

-----Original Message-----
From: Evil Azrael [SMTP:EvilAzrael(at)EvilAzrael(dot)de]
Sent: Sunday, December 31, 2000 8:50 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC-Problem

HI

I have just moved my old MS Access Database to a postgres database via
odbc. all went okay, and i can access the database in MS Access via
ODBC. Only a Client programm that i wrote can?t access the database
anymore via ODBC. The Visual BAsic Database programm says that the
database itself is updateable, but the tables in it aren?t updateable,
and all tries to connect to a table in VB via the OpenRecordset method
fail with the error message "parse error near [name of the table]" or VB
tells that it?s a connection error.
That?s weird.
MS Access has no problems connecting and writing to the database.
VB?s Visual Database Manager can connect to the database, but can only
read tables.
MY VB programm can?t even connect to the tables, but it worked quite
good via ODBC to the Access Database.

I don?t know what i can anymore, so please help if you know a solution.

Christoph Nelles