Re: Code works without Transaction, but not with
- From: "Jon Ley" <JonLey@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 12 Aug 2005 09:16:01 -0700
Fair comment!
Of course, this gives me another potential problem that has already occurred
once in the short time since issuing the fix to the Transaction problem.
Given that Access is now locking pages of records at a time, rather than
individual records, I am more likely to get record locking conflicts. I never
did get around to learning how to write my code to handle this - the
environment I work in rarely has more than one user editing a given record at
any one time, so I haven't needed to.
Jon.
"Allen Browne" wrote:
> Thanks, Jon, but I can't get them to fix even basic stuff like getting
> Access to sort correctly, so I doubt there's any point in sending this to
> them.
>
> This is the sorting problem:
> http://allenbrowne.com/bug-08.html
>
> If find it really embarrassing that Access cannot reliably handle a query
> that is this simple:
> SELECT MyField FROM MyTable ORDER BY MyField DESC;
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jon Ley" <JonLey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:6BAF145F-A68C-4BAD-8C72-F86336DDCBB0@xxxxxxxxxxxxxxxx
> > Allen,
> >
> > Thanks, that's pretty well what I did, except that I needed to close and
> > re-open the database for the change to take effect. I ended up with:
> >
> > If GetOption("Use Row Level Locking") Then
> > SetOption "Use Row Level Locking", False
> > MsgBox "Your database options are set incorrectly and will now " &
> > _
> > "automatically be adjusted. You will need to restart this "
> > & _
> > "application for the corrected settings to take effect.", _
> > vbInformation, "System message ..."
> > Application.Quit
> > End If
> >
> > If you're interested, I have a trimmmed down version of my app and data
> > that
> > will demonstrate the problem. I would be quite happy to let you have this
> > if
> > you think that MS will take any notice.
> >
> > Best regards,
> >
> > Jon.
> >
> >
> > "Allen Browne" wrote:
> >
> >> Very interesting! This appears to be a problem with JET then, not merely
> >> an
> >> issue relating to converting between different versions of JET.
> >>
> >> I did report this issue to MS, but I was not able to get permission from
> >> the
> >> client to give them the large and sensitive database, so AFAIK, they did
> >> not
> >> actually see the problem.
> >>
> >> And for the "But...":
> >> In your startup code, you could include:
> >> Application.SetOption("Use Row Level Locking", 0)
> >>
> >> --
> >> Allen Browne - Microsoft MVP. Perth, Western Australia.
> >> Tips for Access users - http://allenbrowne.com/tips.html
> >> Reply to group, rather than allenbrowne at mvps dot org.
> >
>
>
>
.
- Follow-Ups:
- Re: Code works without Transaction, but not with
- From: Allen Browne
- Re: Code works without Transaction, but not with
- References:
- Code works without Transaction, but not with
- From: Jon Ley
- Re: Code works without Transaction, but not with
- From: Allen Browne
- Re: Code works without Transaction, but not with
- From: Jon Ley
- Re: Code works without Transaction, but not with
- From: Allen Browne
- Re: Code works without Transaction, but not with
- From: Jon Ley
- Re: Code works without Transaction, but not with
- From: Allen Browne
- Code works without Transaction, but not with
- Prev by Date: Re: How do I code an Onclick button to confirm data input on field
- Next by Date: Re: Code works without Transaction, but not with
- Previous by thread: Re: Code works without Transaction, but not with
- Next by thread: Re: Code works without Transaction, but not with
- Index(es):
Relevant Pages
|
