pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpg 7.x and Access 2000 -> #deleted error
5+ messages / 5 participants
[nested] [flat]
* pg 7.x and Access 2000 -> #deleted error
@ 2001-01-22 12:26 Markus Wagner <wagner@imsd.uni-mainz.de>
2001-01-22 15:33 ` Re: pg 7.x and Access 2000 -> #deleted error Ned Lilly <ned@greatbridge.com>
0 siblings, 1 reply; 5+ messages in thread
From: Markus Wagner @ 2001-01-22 12:26 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg 7.x and Access 2000 -> #deleted error
2001-01-22 12:26 pg 7.x and Access 2000 -> #deleted error Markus Wagner <wagner@imsd.uni-mainz.de>
@ 2001-01-22 15:33 ` Ned Lilly <ned@greatbridge.com>
2001-01-22 17:21 ` Re: pg 7.x and Access 2000 -> #deleted error Joel Burton <jburton@scw.org>
2001-01-22 17:54 ` Re: pg 7.x and Access 2000 -> #deleted error Dave Millen <dave@largesalad.co.uk>
0 siblings, 2 replies; 5+ messages in thread
From: Ned Lilly @ 2001-01-22 15:33 UTC (permalink / raw)
To: Markus Wagner <wagner@imsd.uni-mainz.de>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg 7.x and Access 2000 -> #deleted error
2001-01-22 12:26 pg 7.x and Access 2000 -> #deleted error Markus Wagner <wagner@imsd.uni-mainz.de>
2001-01-22 15:33 ` Re: pg 7.x and Access 2000 -> #deleted error Ned Lilly <ned@greatbridge.com>
@ 2001-01-22 17:21 ` Joel Burton <jburton@scw.org>
1 sibling, 0 replies; 5+ messages in thread
From: Joel Burton @ 2001-01-22 17:21 UTC (permalink / raw)
To: Ned Lilly <ned@greatbridge.com>; +Cc: Markus Wagner <wagner@imsd.uni-mainz.de>; pgsql-interfaces
> > 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg 7.x and Access 2000 -> #deleted error
2001-01-22 12:26 pg 7.x and Access 2000 -> #deleted error Markus Wagner <wagner@imsd.uni-mainz.de>
2001-01-22 15:33 ` Re: pg 7.x and Access 2000 -> #deleted error Ned Lilly <ned@greatbridge.com>
@ 2001-01-22 17:54 ` Dave Millen <dave@largesalad.co.uk>
1 sibling, 0 replies; 5+ messages in thread
From: Dave Millen @ 2001-01-22 17:54 UTC (permalink / raw)
To: Markus Wagner <wagner@imsd.uni-mainz.de>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: pg 7.x and Access 2000 -> #deleted error
@ 2001-01-22 17:51 Michael Davis <mdavis@sevainc.com>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Davis @ 2001-01-22 17:51 UTC (permalink / raw)
To: 'Markus Wagner' <wagner@imsd.uni-mainz.de>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-01-22 17:54 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-22 12:26 pg 7.x and Access 2000 -> #deleted error Markus Wagner <wagner@imsd.uni-mainz.de>
2001-01-22 15:33 ` Ned Lilly <ned@greatbridge.com>
2001-01-22 17:21 ` Joel Burton <jburton@scw.org>
2001-01-22 17:54 ` Dave Millen <dave@largesalad.co.uk>
2001-01-22 17:51 RE: pg 7.x and Access 2000 -> #deleted error Michael Davis <mdavis@sevainc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox