pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
#DELETED error when using Access 2000 as frontend
4+ messages / 4 participants
[nested] [flat]

* #DELETED error when using Access 2000 as frontend
@ 2001-01-21 11:03 Markus Wagner <mawagner@mail.uni-mainz.de>
  2001-01-25 03:55 ` Re: #DELETED error when using Access 2000 as frontend Ian Harding <iharding@pakrat.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Markus Wagner @ 2001-01-21 11:03 UTC (permalink / raw)
  To: pgsql-sql

Hi,

I tried to subscribe to pgsql-interfaces several times and received "user not 
found". I also searched the pgsql-interfaces archives, without success. So 
here is my problem.

I want to use pg 7.x as a backend for a MS Access application. I linked a 
table via ODBC, using the newest ODBC driver. I can open and view tables. But 
after I insert a new record, all fields will contain "#deleted". When I 
reopen the table, the inserted data is displayed correctly.

How can I fix this?

Thank you,

Markus






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: #DELETED error when using Access 2000 as frontend
  2001-01-21 11:03 #DELETED error when using Access 2000 as frontend Markus Wagner <mawagner@mail.uni-mainz.de>
@ 2001-01-25 03:55 ` Ian Harding <iharding@pakrat.com>
  2001-01-26 18:42   ` Re: #DELETED error when using Access 2000 as frontend Emils Klotins <emils@home.grafton.lv>
  0 siblings, 1 reply; 4+ messages in thread

From: Ian Harding @ 2001-01-25 03:55 UTC (permalink / raw)
  To: pgsql-sql

Markus Wagner wrote:

> Hi,
>
> I tried to subscribe to pgsql-interfaces several times and received "user not
> found". I also searched the pgsql-interfaces archives, without success. So
> here is my problem.
>
> I want to use pg 7.x as a backend for a MS Access application. I linked a
> table via ODBC, using the newest ODBC driver. I can open and view tables. But
> after I insert a new record, all fields will contain "#deleted". When I
> reopen the table, the inserted data is displayed correctly.
>
> How can I fix this?
>
> Thank you,
>
> Markus

I recall seeing an MS Access 2000 bug that will cause this.  I don't remember
the details, but I suspect a search of the knowledgebase at Microsoft (as soon
as their dns is fixed -  they must be upgrading to windows 2000;^) will yield
the answer.

Ian




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: #DELETED error when using Access 2000 as frontend
  2001-01-21 11:03 #DELETED error when using Access 2000 as frontend Markus Wagner <mawagner@mail.uni-mainz.de>
  2001-01-25 03:55 ` Re: #DELETED error when using Access 2000 as frontend Ian Harding <iharding@pakrat.com>
@ 2001-01-26 18:42   ` Emils Klotins <emils@home.grafton.lv>
  2001-01-27 01:24     ` Re: #DELETED error when using Access 2000 as frontend Colin Faber <cfaber@fpsn.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Emils Klotins @ 2001-01-26 18:42 UTC (permalink / raw)
  To: pgsql-sql

> > I want to use pg 7.x as a backend for a MS Access application. I linked a
> > table via ODBC, using the newest ODBC driver. I can open and view tables. But
> > after I insert a new record, all fields will contain "#deleted". When I
> > reopen the table, the inserted data is displayed correctly.
> I recall seeing an MS Access 2000 bug that will cause this.  I don't remember
I can confirm the problem exists at least in access'97 -- applying 
both of the office'97 service packs helped.

I have noticed all kinds of weird errors in Access which makes it 
operate badly with Postgres and I really can't recommend it as a 
frontend application, although I know there are people who use it 
quite successfully.

On a side note - pls reply privately - what Win frontends (apart from 
web) have people used with Postgres, which work OK for them?

Emils


----------------------
Emils Klotins
IT Manager, Baltic states
Grafton Entertainment Ltd. / TVNET
40-43 Brivibas Str., Riga LV1050, Latvia
+371-7-242-001



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: #DELETED error when using Access 2000 as frontend
  2001-01-21 11:03 #DELETED error when using Access 2000 as frontend Markus Wagner <mawagner@mail.uni-mainz.de>
  2001-01-25 03:55 ` Re: #DELETED error when using Access 2000 as frontend Ian Harding <iharding@pakrat.com>
  2001-01-26 18:42   ` Re: #DELETED error when using Access 2000 as frontend Emils Klotins <emils@home.grafton.lv>
@ 2001-01-27 01:24     ` Colin Faber <cfaber@fpsn.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Colin Faber @ 2001-01-27 01:24 UTC (permalink / raw)
  To: ; +Cc: pgsql-sql

these are common errors on the mysql side also. Most likely poor planing on the
Access end.


Emils Klotins wrote:

> > > I want to use pg 7.x as a backend for a MS Access application. I linked a
> > > table via ODBC, using the newest ODBC driver. I can open and view tables. But
> > > after I insert a new record, all fields will contain "#deleted". When I
> > > reopen the table, the inserted data is displayed correctly.
> > I recall seeing an MS Access 2000 bug that will cause this.  I don't remember
> I can confirm the problem exists at least in access'97 -- applying
> both of the office'97 service packs helped.
>
> I have noticed all kinds of weird errors in Access which makes it
> operate badly with Postgres and I really can't recommend it as a
> frontend application, although I know there are people who use it
> quite successfully.
>
> On a side note - pls reply privately - what Win frontends (apart from
> web) have people used with Postgres, which work OK for them?
>
> Emils
>
> ----------------------
> Emils Klotins
> IT Manager, Baltic states
> Grafton Entertainment Ltd. / TVNET
> 40-43 Brivibas Str., Riga LV1050, Latvia
> +371-7-242-001




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-01-27 01:24 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-21 11:03 #DELETED error when using Access 2000 as frontend Markus Wagner <mawagner@mail.uni-mainz.de>
2001-01-25 03:55 ` Ian Harding <iharding@pakrat.com>
2001-01-26 18:42   ` Emils Klotins <emils@home.grafton.lv>
2001-01-27 01:24     ` Colin Faber <cfaber@fpsn.net>

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