fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

Hello,
Two questions - hence the weird subject.

First, anyone had luck with the Enumerating user accounts in a NT Domain
module by Dev Ashish on Access Web
(http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
return.

Also, I am developing my first split database - BE to reside on a file
server and the FE to be distributed (and updated with Tony Toews incredibly
handy Auto FE Updater). However, in playing with the split today, I
realized that the LDB will reside on each user's machine. So, my plans to
read the LDB for logged in users is scrapped.

For me, the distributed FE far outweighs the advantage of seeing who's
logged in. But, I'm hoping that, maybe, there is a trick I haven't yet come
across (aside from upgrading to A2K!). ??

Any assistance is appreciated.
Thanks
Pat

re: fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

What were you going to do with the information about who was logged in?
Perhaps there is another way to accomplish it. You can, assuming you secure
the DB so that people have to log in with a userid and password, write your
own log as users start and quit the application; or, you could code an
automatic quit based on data in the backend that could only be updated by
the administrator; or some other thing.

I have implemented a periodic check of a central "communication" table in
both an Access client to a server database and an Access front-end in a
multiuser environment to allow the adminstrator to, first, give warning and
then, to force users off before shutting down for maintenance or other
purposes. That code is in the client app or the front end.

Larry Linson
Microsoft Access MVP



"Pat" <pat@noemail.ihatespam.bum> wrote in message
news:vvllb.5154$1U2.776@twister.austin.rr.com...[color=blue]
> Hello,
> Two questions - hence the weird subject.
>
> First, anyone had luck with the Enumerating user accounts in a NT Domain
> module by Dev Ashish on Access Web
> (http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
> return.
>
> Also, I am developing my first split database - BE to reside on a file
> server and the FE to be distributed (and updated with Tony Toews[/color]
incredibly[color=blue]
> handy Auto FE Updater). However, in playing with the split today, I
> realized that the LDB will reside on each user's machine. So, my plans to
> read the LDB for logged in users is scrapped.
>
> For me, the distributed FE far outweighs the advantage of seeing who's
> logged in. But, I'm hoping that, maybe, there is a trick I haven't yet[/color]
come[color=blue]
> across (aside from upgrading to A2K!). ??
>
> Any assistance is appreciated.
> Thanks
> Pat
>
>[/color]

re: fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

Excellent question. The db will not be secured with workgroup security. I
was mostly considering it as a "just in case" feature so, if I did need to
take the db down, I could know which connected user(s) I needed to track
down.

I was basically trying to side-step the additional effort of creating a
timer-based check, with which I could also force someone out. I just didn't
think I needed to go that far. I suppose I could still create a log table
on login/logout for each user to track who is in, but I was hoping there
might be something already out there.


"Larry Linson" <bouncer@localhost.not> wrote in message
news:JBmlb.25657$Ee6.11436@nwrddc01.gnilink.net...[color=blue]
> What were you going to do with the information about who was logged in?
> Perhaps there is another way to accomplish it. You can, assuming you[/color]
secure[color=blue]
> the DB so that people have to log in with a userid and password, write[/color]
your[color=blue]
> own log as users start and quit the application; or, you could code an
> automatic quit based on data in the backend that could only be updated by
> the administrator; or some other thing.
>
> I have implemented a periodic check of a central "communication" table in
> both an Access client to a server database and an Access front-end in a
> multiuser environment to allow the adminstrator to, first, give warning[/color]
and[color=blue]
> then, to force users off before shutting down for maintenance or other
> purposes. That code is in the client app or the front end.
>
> Larry Linson
> Microsoft Access MVP
>
>
>
> "Pat" <pat@noemail.ihatespam.bum> wrote in message
> news:vvllb.5154$1U2.776@twister.austin.rr.com...[color=green]
> > Hello,
> > Two questions - hence the weird subject.
> >
> > First, anyone had luck with the Enumerating user accounts in a NT Domain
> > module by Dev Ashish on Access Web
> > (http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
> > return.
> >
> > Also, I am developing my first split database - BE to reside on a file
> > server and the FE to be distributed (and updated with Tony Toews[/color]
> incredibly[color=green]
> > handy Auto FE Updater). However, in playing with the split today, I
> > realized that the LDB will reside on each user's machine. So, my plans[/color][/color]
to[color=blue][color=green]
> > read the LDB for logged in users is scrapped.
> >
> > For me, the distributed FE far outweighs the advantage of seeing who's
> > logged in. But, I'm hoping that, maybe, there is a trick I haven't yet[/color]
> come[color=green]
> > across (aside from upgrading to A2K!). ??
> >
> > Any assistance is appreciated.
> > Thanks
> > Pat
> >
> >[/color]
>
>[/color]

re: fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

"Pat" <pat@noemail.ihatespam.bum> wrote in message
news:vvllb.5154$1U2.776@twister.austin.rr.com...[color=blue]
> Hello,
> Two questions - hence the weird subject.
>
> First, anyone had luck with the Enumerating user accounts in a NT Domain
> module by Dev Ashish on Access Web
> (http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
> return.
>
> Also, I am developing my first split database - BE to reside on a file
> server and the FE to be distributed (and updated with Tony Toews[/color]
incredibly[color=blue]
> handy Auto FE Updater). However, in playing with the split today, I
> realized that the LDB will reside on each user's machine. So, my plans to
> read the LDB for logged in users is scrapped.
>
> For me, the distributed FE far outweighs the advantage of seeing who's
> logged in. But, I'm hoping that, maybe, there is a trick I haven't yet[/color]
come[color=blue]
> across (aside from upgrading to A2K!). ??
>
> Any assistance is appreciated.
> Thanks
> Pat
>
>[/color]

Best place to get answers is at the official MVP site:
http://mvp.org
Emile Gillespie MVP

re: fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

Pat,

Well the 'backend' on your file server will create a ldb when a user
connects to it unless you are using unbound forms or some kinds of
stateless data display method on your front end (which I doubt you
would be, but hey you never know). You can just interogate that (the
ldb).

Why don't you use Microsofts Msldbusr.dll - this dll can be used to
interogate the ldb file and return all sort of info.

Do a search for Msldbusr.dll on google or download the Msldbusr.exe
and consult the help documentation.

If you want some sample code for how it's used just post back and I
put it on the NG.

Otherwise just use the LDBView.exe to check the .ldb file (that way
you don't need to write a line of code).

Peter

"Pat" <pat@noemail.ihatespam.bum> wrote in message news:<vvllb.5154$1U2.776@twister.austin.rr.com>...[color=blue]
> Hello,
> Two questions - hence the weird subject.
>
> First, anyone had luck with the Enumerating user accounts in a NT Domain
> module by Dev Ashish on Access Web
> (http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
> return.
>
> Also, I am developing my first split database - BE to reside on a file
> server and the FE to be distributed (and updated with Tony Toews incredibly
> handy Auto FE Updater). However, in playing with the split today, I
> realized that the LDB will reside on each user's machine. So, my plans to
> read the LDB for logged in users is scrapped.
>
> For me, the distributed FE far outweighs the advantage of seeing who's
> logged in. But, I'm hoping that, maybe, there is a trick I haven't yet come
> across (aside from upgrading to A2K!). ??
>
> Any assistance is appreciated.
> Thanks
> Pat[/color]

re: fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

Chuck,
Thanks for the reply. I'm actually calling the function in the debug window
right now. If I run it with no arguments, I get a return of admin users on
my machine, then "true" at the end of the list. When I run it with the
network domain name, all I get is true.
??


"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
news:u1kcpvcq1ccdnef4scnaelqv0fbvdlb26t@4ax.com...[color=blue]
>
> Dev's code will work, but it has all it's information routed to the
> debug window. You will want to change that to printing to somewhere
> you can use/see it.
>
> "Function fEnumDomainUsers_Level2" returns a Boolean, which is where
> you're getting that "True" from. Change it's return to "As String"
> and then replace every instance of "Debug.Print" to
> "fEnumDomainUsers_Level2 = fEnumDomainUsers_Level2 & " <whatever> " &
> vbNew line"
>
> Example:
>
> Debug.Print "Home Directory: ", fStrFromPtrW(.usri2_home_dir)
>
> becomes:
>
> fEnumDomainUsers_Level2 = fEnumDomainUsers_Level2 & _
> "Home Directory: ", fStrFromPtrW(.usri2_home_dir) & _
> vbNewLine
>
>
> "Sub sPrintAccountInfo" will also need to be changed to a function
> that returns a string, and debug.print statements changed to
> "sPrintAccountInfo & sPrintAccountInfo & " <whatever> " & vbNewLine"
> in the same method as above.
>
> You will *not* want to return all that information however, so just do
> it on the lines you want to use, then comment out the rest.
>
>
> On Wed, 22 Oct 2003 01:58:51 GMT, "Pat" <pat@noemail.ihatespam.bum>
> wrote:
>[color=green]
> >Hello,
> >Two questions - hence the weird subject.
> >
> >First, anyone had luck with the Enumerating user accounts in a NT Domain
> >module by Dev Ashish on Access Web
> >(http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
> >return.
> >
> >Also, I am developing my first split database - BE to reside on a file
> >server and the FE to be distributed (and updated with Tony Toews[/color][/color]
incredibly[color=blue][color=green]
> >handy Auto FE Updater). However, in playing with the split today, I
> >realized that the LDB will reside on each user's machine. So, my plans[/color][/color]
to[color=blue][color=green]
> >read the LDB for logged in users is scrapped.
> >
> >For me, the distributed FE far outweighs the advantage of seeing who's
> >logged in. But, I'm hoping that, maybe, there is a trick I haven't yet[/color][/color]
come[color=blue][color=green]
> >across (aside from upgrading to A2K!). ??
> >
> >Any assistance is appreciated.
> >Thanks
> >Pat
> >[/color]
>
>
> --
> A Fanatic Is One Who Can't Change His Mind And Won't Change The[/color]
Subject.[color=blue]
>[/color]

re: fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE

pat@noemail.ihatespam.bum (Pat) wrote in
<vvllb.5154$1U2.776@twister.austin.rr.com>:

[]
[color=blue]
>Also, I am developing my first split database - BE to reside on a
>file server and the FE to be distributed (and updated with Tony
>Toews incredibly handy Auto FE Updater). However, in playing with
>the split today, I realized that the LDB will reside on each
>user's machine. So, my plans to read the LDB for logged in users
>is scrapped.[/color]

Well, you want to use the LDB on the server, the one for the shared
MDB. All you then need is to get the name of the back end and then
you're set. Here's a function that does the job:

Public Function getBackEndPath(strTableName As String) As String
' DWF, CREATED ?, REVISED 2001/07/26
' RETURNS vbNullString WHEN NOT A LINKED TABLE
Dim rs As Recordset
Dim db As Database
Dim strDatabase As String

Set db = CurrentDb()
Set rs = db.OpenRecordset("SELECT MSysObjects.Database, _
MSysObjects.Name FROM MSysObjects _
WHERE (((MSysObjects.Name)='" & strTableName & "'));")
If rs.RecordCount = 0 Then
MsgBox "Error in 'getBackEndPath()'. " _
& strTableName & " not found in MSysObjects."
getBackEndPath = "ERROR"
Else
rs.MoveFirst
If IsNull(rs!Database) Then
strDatabase = vbNullString
Else
strDatabase = rs!Database
End If
End If

rs.Close
Set rs = Nothing
End Function

Another method is:

Mid(CurrentDB.TableDefs([linked table name]).Connect,11)

That throws error 3265 when the table is not found, so you might
wrap it in a function with an error handler.
[color=blue]
>For me, the distributed FE far outweighs the advantage of seeing
>who's logged in. But, I'm hoping that, maybe, there is a trick I
>haven't yet come across (aside from upgrading to A2K!). ??[/color]

Looking at the right LDB will take care of the problem.

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