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@xxxxxxxxxxxxxx [mailto:pgsql-odbc-owner@xxxxxxxxxxxxxx] 
De la part de Guy Steven
Envoyé : jeudi, 8. janvier 2004 01:32
À : pgsql-odbc@xxxxxxxxxxxxxx
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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings