From: Michael Davis <mdavis@sevainc.com>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: RE: ODBC-Problem
Date: Tue, 2 Jan 2001 17:54:17 -0700
Message-ID: <01C074E5.086196C0.mdavis@sevainc.com> (raw)
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@EvilAzrael.de]
Sent: Sunday, December 31, 2000 8:50 PM
To: pgsql-interfaces@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mdavis@sevainc.com
Subject: RE: ODBC-Problem
In-Reply-To: <01C074E5.086196C0.mdavis@sevainc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox