Bad locking with MS-Access

From: "Ets ROLLAND" <ets(at)rolland-fr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Bad locking with MS-Access
Date: 2005-07-22 08:06:48
Message-ID: 002401c58e94$4f9eac30$6400a8c0@lrp43208
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

I look for the the options / advanced tab of that MS-database, I don't find an issue.
I look for the parameters of my ODBC system daya source without success.
I don't find any solution with PostgreSQL...

BUT if I modify any field in one of these locked records with the browser of pgAdmin III,
then MS-Access accept to modify or delete the corresponding record !?
If I write an SQL script to do the same in pgAdmin III (ex. add zero to an integer value),
it don't works !

I'm going crazy !...
HELP !

Luc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kilian Hagemann 2005-07-22 08:46:39 Re: Query planner refuses to use index
Previous Message Richard Huxton 2005-07-22 07:31:08 Re: Connection error