This sounds strange. I can connect to many tables in less than a minute.
I can open tables in seconds regardless of how many rows are in the
tables. Access usually only selects 20-30 rows at a time. My ODBC
connections to PostgreSQL in Access are fast. Not as fast as opening local
Access tables by much faster than 1 minute. You can try different options
in your connect statement. Some options work with ODBC, others don't. If
this does not help, you will have to email me your VBA code.
From: Evil Azrael [SMTP:EvilAzrael(at)EvilAzrael(dot)de]
Sent: Wednesday, January 03, 2001 1:44 AM
Subject: Re: ODBC-Problem
thanx for the answer.
i have in every table a primary index called ID, but ODBC and VB don?t
accept it as a primary keys. and the performance of the OBDC connection
is rather bad. he needs almost 1 minute to connect to a table with 300k
rows, for just appending a few lines. even sql calls fails. i postponed
the whole transfer for a time and check it then again.
but thanx for the reply
Michael Davis wrote:
> 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
> 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
> 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
pgsql-interfaces by date
|Next:||From: Michael Davis||Date: 2001-01-03 16:12:14|
|Subject: RE: ODBC - Invalid protocol character|
|Previous:||From: Michael Davis||Date: 2001-01-03 16:00:06|
|Subject: RE: Access using Postgres|