[AccessD] Record locking

Debbie delam at zyterra.com
Mon Jun 7 09:06:22 CDT 2010


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
>



More information about the AccessD mailing list