[AccessD] Record locking

I don't know if user 2 issuing a Me.Dirty = False will clear the problem.
Maybe someone else knows.  

Failing that, how about issuing the Me.Dirty = False in a key place in the
code - like maybe the form's After Update event - to reduce the problem or
maybe eliminate it. 

At least you could trap the locking error, give the user a descriptive
message with maybe an option to retry the update?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
Sent: Monday, June 07, 2010 7:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Record locking

Trouble is the error is happening on the user that is not dirty. The user
that is dirty is working fine, he just locks at least one other user out
while he is dirty.

Debbie

Sent from my iPhone

On Jun 7, 2010, at 8:53 AM, "Rocky Smolin" <rockysmolin at bchacc.com>
wrote:

> Can you trap the locking error and issue a Me.Dirty = False in the 
> error routine then Resume Next?
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
> Sent: Monday, June 07, 2010 6:47 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Record locking
>
> I have a form that locks other users out when the form is dirty. I 
> have tried lots of things including explicitly setting locking to no 
> locks and saving on dirty with code. Unless someone can give me a new 
> idea, I think I am going to have to try and rebuild the form as 
> unbound.  Can anyone offer any alternative methods?
>
> Debbie
>
> Sent from my iPhone
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com