Home » Open Source » Programming Interfaces » Locked individual records only for individual users on MS ACCESS (Oracle 10g)
Locked individual records only for individual users on MS ACCESS [message #638463] Fri, 12 June 2015 04:42 Go to next message
vinczej
Messages: 12
Registered: June 2015
Junior Member
Hi!

I'm maintaining Oracle database by MS ACCESS. I have some records in a table, that are locked with message:
"The database engine stopped the process because you and another user are attempting to change the same data at the same time."

It's strange, that it affects only some (but always the same) records in the same table, but only for me, not any other user. What can be the problem? Shocked

Thanks forward!
Re: Locked individual records only for individual users on MS ACCESS [message #638466 is a reply to message #638463] Fri, 12 June 2015 05:29 Go to previous messageGo to next message
Roachcoach
Messages: 1498
Registered: May 2010
Location: UK
Senior Member
Most likely MS access.

Maybe want to look at using a proper tool to manage the database, like sql plus or one of the more traditional oracle GUIS if you need it.
Re: Locked individual records only for individual users on MS ACCESS [message #638467 is a reply to message #638463] Fri, 12 June 2015 05:38 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
How do the other users access this database?
Re: Locked individual records only for individual users on MS ACCESS [message #638471 is a reply to message #638467] Fri, 12 June 2015 05:59 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

>What can be the problem?

Problem Exists Between Keyboard And Chair

[Updated on: Fri, 12 June 2015 07:27]

Report message to a moderator

Re: Locked individual records only for individual users on MS ACCESS [message #638493 is a reply to message #638463] Fri, 12 June 2015 07:28 Go to previous messageGo to next message
vinczej
Messages: 12
Registered: June 2015
Junior Member
Thanks for replies!

I think, that the problem comes from difference of settings of ODBC or Terminal Server by several users. I will give feedback, if the problem will be solved.
Re: Locked individual records only for individual users on MS ACCESS [message #638494 is a reply to message #638463] Fri, 12 June 2015 07:45 Go to previous messageGo to next message
John Watson
Messages: 7183
Registered: January 2010
Location: Global Village
Senior Member
I remember (this is from some time go) that Access couldn't do row level locking: it locked what I think they called a "page". As far as Oracle is concerned, it receives a request to lock many rows, or perhaps the whole table, and it just does what it is asked to do. It can be difficult in the ORacle environment to work out who has locked which rows, but there are tools that will help. I find the old utllockt.sql script useful for this.
Re: Locked individual records only for individual users on MS ACCESS [message #638659 is a reply to message #638463] Wed, 17 June 2015 02:09 Go to previous messageGo to next message
vinczej
Messages: 12
Registered: June 2015
Junior Member
Our admins has found the cause of the problem. The difference between users can modify and users can't modify some records is, that the problem affects the 32 bit version of the MS Access. The MS Access 64 bit version works smoothly. Supposedly the cause may be any NULL data. Thanks for replies!

[Updated on: Wed, 17 June 2015 02:10]

Report message to a moderator

Re: Locked individual records only for individual users on MS ACCESS [message #638661 is a reply to message #638659] Wed, 17 June 2015 02:53 Go to previous message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback.

Previous Topic: Unable to connect to a remote database through ASP. NET ( ASPHostPortal.com)
Next Topic: insert into db via perl dbi
Goto Forum:
  


Current Time: Wed Dec 13 23:03:45 CST 2017

Total time taken to generate the page: 0.02093 seconds