Re: Please help with a serious issue


Ok, new information. It turns out that when they get that error(row cannot
be located for updating) they are both invoicing customers that are right
after each other in the database. I read that Access locks the record you
are updating as well as the previous and next record as sort of a buffer i
guess. Is there a way around this? They will have this situation more often
than not, it will almost be every time they are invoicing.
I really need a solution to this or i will have to switch the software to
run to a local database and update each night to the server. The client
really does not want this.
Any help you can give would be greatly appreciated.
Thanks again,
David L. Bracken

If you are using clientside cursors as you claim then the lock placed for
updating the record will be placed when you post a record and removed as soon as
the post succeeds. You can do some testing to see if two users trying to post
records next to each other simultaneously try to post and have this problem vs
One waiting for the other to post and then trying the post.
If there is an error in the first situation the user should be able to post the
record on a second try because the lock will be removed by the time the user has
read the error.
I have never seen this come up before so I am sceptical that its happening often
enough in your application to case a problem.
You can't change Accesses Locking behavior so a fix is moving to SQL server or
some other database.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Record Locking
    ... the database have 11 records now. ... They can read but they can't place another lock to the records ... Since this is a dynamic recordset, I will have 11th records in my recordset. ... The record will be locked when editing and updating if using ...
    (microsoft.public.vb.database.ado)
  • Re: Parameterization of Object Models
    ... Lock down Access to the system -- ... Attempt to prevent deadlocks see The Concepts of Database Management, ... recovery; that is, you say that you recovered the database. ... database (called a backup or a save). ...
    (comp.lang.misc)
  • Re: datagrid update command
    ... -i display it on a textbox on the form b4 updating the dataset ... >> hi sir ... > always cause error says that CType is not defined inmy namespace, ... > how can i update the database or the dataset without knowing the value ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Limit FORM mailer submissions to 5 on website, then pause until reviewed by webmaster
    ... have a script that creates a temporary row in a sessions table as soon ... then don't display the input form and instead display the message, ... You wouldn't lock the file from the time they come to the page until ... the database occurs, ...
    (comp.lang.perl.misc)
  • Re: Running Analysis Server 2000 on seperate box
    ... On further investigation regarding the lock up problem. ... the dimension processing running and although the database rows are ... changing the service account sorted things. ... The server has both the database and Analysis Services ...
    (microsoft.public.sqlserver.olap)