Re: No Current Record

Hello,

I have also experienced similar odd things like that with linked tables and access. Not exactly like in you description, but for me, deleting all linked tables, and relinking them works fine. This is apparently not the same as using the tool from the Option Menu ("Gestionnaire Tables liées" in French), that works fine when you have added a column, though.

I have problems like that when I move an Access database from my computer, linked to a development database, to another, linked to an identical (but separate) production database.

I don't know exactly what Access permanently stores in a linked table connection. Does anyone know?

Philippe Lang

-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Guy Steven
Envoyé : jeudi, 8. janvier 2004 01:32
À : pgsql-odbc(at)postgresql(dot)org
Objet : [ODBC] No Current Record

I am experiencing a very frustrating problem with postgresql and access 2000.

I have a postgresql 7.2.4-5.80 database and am accessing it using access 2000.
Tables are linked using odbc.

I can read a table. I can add records to a table. I can edit and delete existing records in the table, but I can not edit or delete records in the table that were added using the odbc connection. By this I mean that records that are imported into the postgresql (from a dump from pg_dump) can be edited or deleted, but if I add a record from access, I can't edit or delete from access.
From within psql the records look identical.
The error message I get is No Current Record.

Guy Steven

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html