OraFAQ Forum: Programming Interfaces » Locked individual records only for individual users on MS ACCESS

Home » Open Source » Programming Interfaces » Locked individual records only for individual users on MS ACCESS (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Locked individual records only for individual users on MS ACCESS [message #638463]

Fri, 12 June 2015 04:42

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!

Report message to a moderator

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

Roachcoach
Messages: 1576
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.

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

How do the other users access this database?

Report message to a moderator

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

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

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

John Watson
Messages: 8962
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.

Report message to a moderator

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 09:42:30 CST 2024