Thread: pg 7.x and Access 2000 -> #deleted error
Hi, I am using pg 7.x as a db server and MS Access should be the frontend for windows clients. I installed the newest ODBC driver on the windows machine. I can link in and open tables from the pg server. But when I make changes/inserts, all fields of the current record will contain "#deleted". I have to close and reopen the table to see the newly entered/changed data. Any hints to get this working? Thanks, Markus
Hi Markus, I think this is an Access issue - I seem to recall having the same problem with an Access front-end to Oracle a year or so ago. Regards, Ned Markus Wagner wrote: > Hi, > > I am using pg 7.x as a db server and MS Access should be the frontend > for windows clients. I installed the newest ODBC driver on the windows > machine. I can link in and open tables from the pg server. But when I > make changes/inserts, all fields of the current record will contain > "#deleted". I have to close and reopen the table to see the newly > entered/changed data. > > Any hints to get this working? > > Thanks, > > Markus > > -- ---------------------------------------------------- Ned Lilly e: ned@greatbridge.com Vice President w: www.greatbridge.com Evangelism / Hacker Relations v: 757.233.5523 Great Bridge, LLC f: 757.233.5555
> > Hi, > > > > I am using pg 7.x as a db server and MS Access should be the frontend > > for windows clients. I installed the newest ODBC driver on the windows > > machine. I can link in and open tables from the pg server. But when I > > make changes/inserts, all fields of the current record will contain > > "#deleted". I have to close and reopen the table to see the newly > > entered/changed data. > > > > Any hints to get this working? It's a FAQ: www.scw.org/pgaccess -- Joel Burton <jburton@scw.org> Director of Information Systems, Support Center of Washington
Is there a primary key installed on the table? Is "Recognize Unique Indexed" enabled in the ODBC drivers data source? Make sure both of these are true solved a similar problem for me with Access 97. -----Original Message----- From: Markus Wagner [SMTP:wagner@imsd.uni-mainz.de] Sent: Monday, January 22, 2001 5:26 AM To: pgsql-interfaces@postgresql.org Subject: pg 7.x and Access 2000 -> #deleted error Hi, I am using pg 7.x as a db server and MS Access should be the frontend for windows clients. I installed the newest ODBC driver on the windows machine. I can link in and open tables from the pg server. But when I make changes/inserts, all fields of the current record will contain "#deleted". I have to close and reopen the table to see the newly entered/changed data. Any hints to get this working? Thanks, Markus
Hi, This is usually fixed by ensuring that your tables have both a primary key and a timestamp field. regards, Dave Ned Lilly wrote: > Hi Markus, > > I think this is an Access issue - I seem to recall having the same > problem with an Access front-end to Oracle a year or so ago. > > Regards, > Ned > > Markus Wagner wrote: > > > Hi, > > > > I am using pg 7.x as a db server and MS Access should be the frontend > > for windows clients. I installed the newest ODBC driver on the windows > > machine. I can link in and open tables from the pg server. But when I > > make changes/inserts, all fields of the current record will contain > > "#deleted". I have to close and reopen the table to see the newly > > entered/changed data. > > > > Any hints to get this working? > > > > Thanks, > > > > Markus > > > > > > -- > ---------------------------------------------------- > Ned Lilly e: ned@greatbridge.com > Vice President w: www.greatbridge.com > Evangelism / Hacker Relations v: 757.233.5523 > Great Bridge, LLC f: 757.233.5555 -- He was part of my dream, of course -- but then I was part of his dream too. -- Lewis Carroll email: dave@largesalad.co.uk web1 : www.largesalad.co.uk web2 : www.p21.co.uk