Re: Bad locking with MS-Access

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