Re: Bad locking with MS-Access

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ets ROLLAND <ets(at)rolland-fr(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bad locking with MS-Access
Date: 2005-07-22 08:51:39
Message-ID: 42E0B39B.1050306@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ets ROLLAND wrote:
> Hello !
>
> I made the port of an Access 2002 Database to PostgreSQL 8, it seems to work.
> I still use MS-Access 2002 for the application, using ODBC with linked tables.
>
> For all the data created BEFORE the transfert to PostgreSQL, all works fine.
> For the records created SINCE this transfert, it is impossible to modify or delete these records !?
> MS-Access say that "The record is acceded by an other user", even I am the only user.

Wild guess - Access is trying to identify rows by looking at the data,
which includes a timestamp. PG supports fractional-seconds which is
confusing Access. All your old timestamps aren't fractional because they
were imported from Access. When you define your timestamps in PG you can
control how much accuracy you want - might be worth dumping/restoring
without the fractions.

Look for a "row versioning" option in your ODBC settings. Also, there's
an ODBC list too - check the mailing-list archives for that.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mario Guenterberg 2005-07-22 09:29:32 Re: Connection error
Previous Message Ezequiel Tolnay 2005-07-22 08:49:00 Re: Dumb question about count()