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
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 |