[AccessD] VBA Unbound data entry / update form

Precisely, which makes the inability to even get a 
discussion going even more discouraging.  JET is widely 
used, page lock issues are real, one would imagine that 
folks would have spent some time thinking about this for jet 
/ unbound.

But it seems a good time to just drop the whole thing.

John W. Colby
www.ColbyConsulting.com


Jim Lawrence wrote:
> Rocky, John
> 
> In the case of an SQL DB BE that whole issue is managed by the DB just as it
> would if with a bound MDB only better.
> 
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, June 10, 2008 9:07 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] VBA Unbound data entry / update form
> 
> Rocky,
> 
> I hate to jump all over your method because I want a method 
> to use, but you are completely ignoring locking / update 
> issues.  What happened if another user updated the record 
> between the time you loaded yours and the time you write it 
> back?
> 
> John W. Colby
> www.ColbyConsulting.com