Group:  Microsoft Access ยป microsoft.public.access.tablesdbdesign
Thread: Find which user has record locked.

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Find which user has record locked.
ThomasAJ 26.09.2006 05:00:01
I have pessimistic locking/edited record.

How do I find out which user has locked a record in a form?

--
Regards
Tom
Re: Find which user has record locked.
"Larry Daugherty" <Larry.NoSpam.Daugherty[ at ]verizon.net> 26.09.2006 15:08:32
I believe that you can find something useful at www.msdn.microsoft.com
Search for LDB View. If you have no joy there then do a search on
those same two terms (put them in quotes) at www.groups.google.com I
know there has been a post in these groups sometime in the last day or
so.

HTH
--
-Larry-
--

"ThomasAJ" <ThomasAJ[ at ]discussions.microsoft.com> wrote in message
news:CC05EED5-64FE-4A1D-B33B-2EDC0D60BC2F[ at ]microsoft.com...
[Quoted Text]
> I have pessimistic locking/edited record.
>
> How do I find out which user has locked a record in a form?
>
> --
> Regards
> Tom


Re: Find which user has record locked.
ThomasAJ 28.09.2006 01:06:01
There is a utility call 'LDB View' but is only good for non-Jet 4.0 DBs
(prior Access 2000). Anyway that would only allow viewing.

I cannot find anything that can programmatically determine who has record
locked and show that to the 'locked out' person. The 'locked out' person
could yell out to the 'locker', "hey you...". I think you know what I mean.

--
Regards
Tom


"Larry Daugherty" wrote:

[Quoted Text]
> I believe that you can find something useful at www.msdn.microsoft.com
> Search for LDB View. If you have no joy there then do a search on
> those same two terms (put them in quotes) at www.groups.google.com I
> know there has been a post in these groups sometime in the last day or
> so.
>
> HTH
> --
> -Larry-
> --
>
> "ThomasAJ" <ThomasAJ[ at ]discussions.microsoft.com> wrote in message
> news:CC05EED5-64FE-4A1D-B33B-2EDC0D60BC2F[ at ]microsoft.com...
> > I have pessimistic locking/edited record.
> >
> > How do I find out which user has locked a record in a form?
> >
> > --
> > Regards
> > Tom
>
>
>
Re: Find which user has record locked.
"Larry Daugherty" <Larry.NoSpam.Daugherty[ at ]verizon.net> 28.09.2006 06:55:55
Now I understand what you mean. Good luck in your search.

--
-Larry-
--

"ThomasAJ" <ThomasAJ[ at ]discussions.microsoft.com> wrote in message
news:ACA36765-67E2-4BC1-B67C-B1FACDF2F318[ at ]microsoft.com...
[Quoted Text]
> There is a utility call 'LDB View' but is only good for non-Jet 4.0
DBs
> (prior Access 2000). Anyway that would only allow viewing.
>
> I cannot find anything that can programmatically determine who has
record
> locked and show that to the 'locked out' person. The 'locked out'
person
> could yell out to the 'locker', "hey you...". I think you know what
I mean.
>
> --
> Regards
> Tom
>
>
> "Larry Daugherty" wrote:
>
> > I believe that you can find something useful at
www.msdn.microsoft.com
> > Search for LDB View. If you have no joy there then do a search on
> > those same two terms (put them in quotes) at www.groups.google.com
I
> > know there has been a post in these groups sometime in the last
day or
> > so.
> >
> > HTH
> > --
> > -Larry-
> > --
> >
> > "ThomasAJ" <ThomasAJ[ at ]discussions.microsoft.com> wrote in message
> > news:CC05EED5-64FE-4A1D-B33B-2EDC0D60BC2F[ at ]microsoft.com...
> > > I have pessimistic locking/edited record.
> > >
> > > How do I find out which user has locked a record in a form?
> > >
> > > --
> > > Regards
> > > Tom
> >
> >
> >


Re: Find which user has record locked.
"lewie" <lewis.krause[ at ]echostar.com> 28.09.2006 20:29:09
Garry Robinson has a good book out about security which has alot of
info in it about creating tables to enter who is logged in ect. you may
google him for info. Whenever we get locked out of a db it lists the
users machine who has it locked out. We have a user group list that has
user phone number and machine number in a spreadsheet. Just look up
number and call.
Lewie
Larry Daugherty wrote:
[Quoted Text]
> Now I understand what you mean. Good luck in your search.
>
> --
> -Larry-
> --
>
> "ThomasAJ" <ThomasAJ[ at ]discussions.microsoft.com> wrote in message
> news:ACA36765-67E2-4BC1-B67C-B1FACDF2F318[ at ]microsoft.com...
> > There is a utility call 'LDB View' but is only good for non-Jet 4.0
> DBs
> > (prior Access 2000). Anyway that would only allow viewing.
> >
> > I cannot find anything that can programmatically determine who has
> record
> > locked and show that to the 'locked out' person. The 'locked out'
> person
> > could yell out to the 'locker', "hey you...". I think you know what
> I mean.
> >
> > --
> > Regards
> > Tom
> >
> >
> > "Larry Daugherty" wrote:
> >
> > > I believe that you can find something useful at
> www.msdn.microsoft.com
> > > Search for LDB View. If you have no joy there then do a search on
> > > those same two terms (put them in quotes) at www.groups.google.com
> I
> > > know there has been a post in these groups sometime in the last
> day or
> > > so.
> > >
> > > HTH
> > > --
> > > -Larry-
> > > --
> > >
> > > "ThomasAJ" <ThomasAJ[ at ]discussions.microsoft.com> wrote in message
> > > news:CC05EED5-64FE-4A1D-B33B-2EDC0D60BC2F[ at ]microsoft.com...
> > > > I have pessimistic locking/edited record.
> > > >
> > > > How do I find out which user has locked a record in a form?
> > > >
> > > > --
> > > > Regards
> > > > Tom
> > >
> > >
> > >

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net