Connecting Tech Pros Worldwide Help | Site Map

Access User Utility

William Wisnieski
Guest
 
Posts: n/a
#1: Nov 12 '05
Hello Everyone,

At one time, I used this great little piece of freeware--a desktop utility
that let me see who was logged on to an Access database over the network.
Of course, now that I've moved on to a new employer and really need it, I
can't remember it for the life of me. Does anyone know of something like
that?

Thanks,

William


F. Michael Miller
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Access User Utility


LDBView.exe will do that.


"William Wisnieski" <wwisnieski@admissions.umass.edu> wrote in message
news:4019340a$1@news-1.oit.umass.edu...[color=blue]
> Hello Everyone,
>
> At one time, I used this great little piece of freeware--a desktop utility
> that let me see who was logged on to an Access database over the network.
> Of course, now that I've moved on to a new employer and really need it, I
> can't remember it for the life of me. Does anyone know of something like
> that?
>
> Thanks,
>
> William
>
>[/color]


William Wisnieski
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Access User Utility


That's the one! Thanks Michael.


"F. Michael Miller" <fmmiv@netzero.net> wrote in message
news:40193c8a$0$41297$a1866201@newsreader.visi.com ...[color=blue]
> LDBView.exe will do that.
>
>
> "William Wisnieski" <wwisnieski@admissions.umass.edu> wrote in message
> news:4019340a$1@news-1.oit.umass.edu...[color=green]
> > Hello Everyone,
> >
> > At one time, I used this great little piece of freeware--a desktop[/color][/color]
utility[color=blue][color=green]
> > that let me see who was logged on to an Access database over the[/color][/color]
network.[color=blue][color=green]
> > Of course, now that I've moved on to a new employer and really need it,[/color][/color]
I[color=blue][color=green]
> > can't remember it for the life of me. Does anyone know of something[/color][/color]
like[color=blue][color=green]
> > that?
> >
> > Thanks,
> >
> > William
> >
> >[/color]
>
>[/color]


Tony Toews
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Access User Utility


"F. Michael Miller" <fmmiv@netzero.net> wrote:
[color=blue]
>LDBView.exe will do that.[/color]

LDBView will show misleading results for Jet 4.0/Access 2000/2002 MDBs as it always
flags the suspect column as yes whenever everyone exits the MDB. For Jet 4.0/Access
2000/2002 See HOW TO: Check Who Logged into Database with Jet UserRoster in Access
2000 http://support.microsoft.com/default...b;en-us;198755
or http://support.microsoft.com/default...b;en-us;285822

Also see LDB Viewer Form which has the above code in a form in an MDB for you.
http://www.mvps.org/access/modules/mdl0055.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
David W. Fenton
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Access User Utility


Tony Toews <ttoews@telusplanet.net> wrote in
news:6upi1055aj2iqnb880os00pd70vcgr4b9c@4ax.com:
[color=blue]
> DBView will show misleading results for Jet 4.0/Access 2000/2002
> MDBs as it always flags the suspect column as yes whenever
> everyone exits the MDB. For Jet 4.0/Access 2000/2002 See HOW TO:
> Check Who Logged into Database with Jet UserRoster in Access 2000
> http://support.microsoft.com/default...b;en-us;198755 or
> http://support.microsoft.com/default...b;en-us;285822[/color]

UserRoster is an ADO feature (one of the few that ADO provides that
is not provided in DAO).

Keep in mind that you can use late binding and not have to keep an
ADO reference.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Closed Thread


Similar Microsoft Access / VBA bytes