Re: Trouble with MsAccess and records above 13000

From: "Gerwin Philippo" <gerwin(at)vernet(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Trouble with MsAccess and records above 13000
Date: 2004-01-09 15:57:55
Message-ID: 3ffecf84$0$316$e4fe514c@news.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Found it. It's in the dsn-file, I checked the option "Row versioning", and
now it works.

"Gerwin Philippo" <gerwin(at)vernet(dot)nl> schreef in bericht
news:3ffeb587$0$314$e4fe514c(at)news(dot)xs4all(dot)nl(dot)(dot)(dot)
> We run a postgres database (7.4) with an MsAcces(2000) frontend, and since
> our last upgrade from 7.2 I have the following problem:
> When I try to edit a record in msacces with a high recordnummer, like a
> record with a primary key field value of 13000, msacces gives me the error
> message that another user has already changed this record...etc.
> This happens with and without any triggers on the table.
> When I update this record directly on the commandline, there is no
problem.
> Does anybody know of this problem?
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Lebedev 2004-01-09 16:44:30 deferring/disabling unique index
Previous Message Tom Lane 2004-01-09 15:25:49 Re: array faults?