Re: Mini Faq

On Wed, 28 Mar 2001, Alen Lovrencic wrote:

> First, I want to say something about one question in your faq that is not
> answered: Differences between Access 2,5, 97 and 2000.

I'm afraid that I have no practical experience w/using PostgreSQL
with versions of Access prior to 97. If you do, please consider
contributing them to the FAQ.

> The main difference between 97 and earlier versions of Access and Access
> 2000 is in the wat it use ODBC source. Namely, 97 and older asks through
> ODBC for whole table, and then Jet Engine try to solve a query locally.
> Access 2000, on the other hand, do ODBC queries correctly. That means that
> whole query is passed through ODBC to PostgreSQL (or whatever RDBMS it is)
> and get an answer to query that is presented to user. That makes Access 2000
> finally appropriate for front-end for databases with larger number of
> records in tables.

I'm not an expert on 97 v 2000 differences, but this doesn't agree with
what I know. AFAIK, 97 and 2000 both run queries locally for linked tables
where the joins are not native to PostgreSQL, or when you use VBA
expressions; both run the queries remotely in other cases, and always do
if you write a Pass-Through query. I could be mistaken about this,
though. If you have any resources you can point me to about this
difference, it would be great.

> Now, my question. I have Access 2000, PostgreSQL 6.5 and ODBC downloaded
> from your site. I have one table which is completely locked all the time. In
> fact, the table is not lock at all, because I can update all data in it from
> PostgreSQL shell, but Access refuse to update any data from it.
> What should I do?

No clue from just this description. What do you mean by "locked"? Does
Access give you an error message, or does it just fail to update?

> It is very important to me top get an answer .

I'm not able to provide technical support directly; I've forwarded your
message to pgsql-interfaces, the appropriate list for discussion of
PostgreSQL + Access stuff.

Good luck w/your problem,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington