[AccessD] Handling concurrent updates

[Gustav Brock]

Thanks Stuart - and Charlotte.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Stuart McLachlan
Sendt: 4. februar 2016 02:27
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Handling concurrent updates

Now that's a neat solution!   <thumb/>  :)
   

On 3 Feb 2016 at 16:01, Gustav Brock wrote:

> Hi all
> 
> If you ever have struggled with this in VBA, you know it's a daunting 
> task with a lot of error handling.
> 
> For a client, I had to find a smarter method. A bit surprisingly, 
> Bing/Google didn't reveal anything useful, so I ended up with two tiny 
> functions to handle edit and update. With these it takes (net) only 
> one line of additional code. It is all described here:
> 
>    http://rdsrc.us/BvX5Gw
> 
> including a demo app and the small code module with the two functions.
> If you have access to a Northwind database running in an SQL Server 
> instance, you can run the test right away. You can also relink to an 
> Access database, but that is less fun as the updates are so fast that 
> collisions are much fewer.
> 
> /gustav