473,856 Members | 1,769 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

fEnumDomainUser s and LDB Viewing on 97 split DB w/ distributed FE

Pat
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
Nov 12 '05 #1
6 1690
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 "communicat ion" 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" <pa*@noemail.ih atespam.bum> wrote in message
news:vv******** ********@twiste r.austin.rr.com ...
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

Nov 12 '05 #2
Pat
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" <bo*****@localh ost.not> wrote in message
news:JB******** ***********@nwr ddc01.gnilink.n et...
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 "communicat ion" 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" <pa*@noemail.ih atespam.bum> wrote in message
news:vv******** ********@twiste r.austin.rr.com ...
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


Nov 12 '05 #3

"Pat" <pa*@noemail.ih atespam.bum> wrote in message
news:vv******** ********@twiste r.austin.rr.com ...
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


Best place to get answers is at the official MVP site:
http://mvp.org
Emile Gillespie MVP
Nov 12 '05 #4
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" <pa*@noemail.ih atespam.bum> wrote in message news:<vv******* *********@twist er.austin.rr.co m>...
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

Nov 12 '05 #5
Pat
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.*******@worl dnet.att.net.in valid> wrote in message
news:u1******** *************** *********@4ax.c om...

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 fEnumDomainUser s_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.Prin t" to
"fEnumDomainUse rs_Level2 = fEnumDomainUser s_Level2 & " <whatever> " &
vbNew line"

Example:

Debug.Print "Home Directory: ", fStrFromPtrW(.u sri2_home_dir)

becomes:

fEnumDomainUser s_Level2 = fEnumDomainUser s_Level2 & _
"Home Directory: ", fStrFromPtrW(.u sri2_home_dir) & _
vbNewLine
"Sub sPrintAccountIn fo" will also need to be changed to a function
that returns a string, and debug.print statements changed to
"sPrintAccountI nfo & sPrintAccountIn fo & " <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" <pa*@noemail.ih atespam.bum>
wrote:
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 incrediblyhandy 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 toread 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 comeacross (aside from upgrading to A2K!). ??

Any assistance is appreciated.
Thanks
Pat
--
A Fanatic Is One Who Can't Change His Mind And Won't Change The

Subject.

Nov 12 '05 #6
pa*@noemail.iha tespam.bum (Pat) wrote in
<vv************ ****@twister.au stin.rr.com>:

[]
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.
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.OpenRecordse t("SELECT MSysObjects.Dat abase, _
MSysObjects.Nam e 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!Datab ase) Then
strDatabase = vbNullString
Else
strDatabase = rs!Database
End If
End If

rs.Close
Set rs = Nothing
End Function

Another method is:

Mid(CurrentDB.T ableDefs([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.
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!). ??


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
Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2283
by: Constandinos Mavromoustakis | last post by:
CFP: CLADE 2004-Challenges of Large Applications in Distributed Environments ------------------------------------------------- PhD student - Dept.Informatics at Aristotle University of Thessaloniki URL-> http://agent.csd.auth.gr/~cmavrom -------------------------------------------------- -------------------------CLADE 2004--------------------------- Challenges of Large Applications in Distributed Environments June 7th, 2004, Honolulu,...
9
1779
by: martin | last post by:
Hi, a very newbie question. How do I split the adress and number to 2 variables? ex. "Kingsroad 347" = variabel1 = "Kingsroad" variabel2 = "347" Ill guess i have to search the string from left to right after first apperence of a number, but how do i do that? Regards Martin
0
2471
by: DotNetJunkies User | last post by:
I am writing a distributed transaction code. My current scenario include a client database(Suppose client- having 4 main database) which can be installed anywhere which would connect to a public database placed at ISP datacentre(Suppose Server- having 2 database). this server database is added to client as linked server through vb.net interface. i have a transmission routine which transmitts the data from the client to Server and update client...
3
1851
by: Joris Dobbelsteen | last post by:
Dear, I have some considerations I need to take designing a distributed application (it's for a school project). Basically I'm looking for some reference or guidiance material/literature and advises on (potential) issues I should take caution for. The design involves a distributed simulation application. It simulates sheeps in a pasture, together with dogs, wolves and shepherd. The pastures contain grass. There are also multiple...
1
3012
by: Rhino | last post by:
Is there any way to install the IBM Distributed Debugger V9.2 on Windows XP without first uninstalling DB2? I installed the IBM Distributed Debugger V9.2 on my Windows XP box in the hopes of debugging a Java stored procedure. Well, I never got the debugger to work despite my best efforts - see posts earlier this week - so now I'd like to uninstall the debugger. I looked into this but the README says: 3.1 Uninstalling on Windows
2
3900
by: John Lee | last post by:
Hi, I have few questions related to .NET 2.0 TransactionScope class behavior: 1. Check Transaction.Current.TransactionInformation.DistributedIdentifier to identify if distributed transaction is used - is it accurate way? 2. I have the following code blocks - In code block 1, the first check the DistributedIdentifier is ALL 0s so it
4
2828
by: tsui | last post by:
Dear all Someone say that past is Client/Server application, and now is distributed application, but i don't understand these terms Is it Client/Server application is mean two tiers, and only one server can not be web farm or cluster, and asp and vb can be a client/server app and is it distributed application is mean more than two tiers, and can more than one server ????????????
10
5316
by: NH | last post by:
I have a girdview with paging enabled. How can I add a message in the footer to say "Viewing records 1-15 of 45" etc Thanks
2
1238
by: radink | last post by:
Hey all, I have my DB up and running. I split it and have the MDE file on the server and the front end part on my machine. Before I split it I could open the time card form and see all of the previous time cards. Same thing with the project list i have. Since I've split it, when I open the time card form, I can't see any previous data, but it is in the table. I can, however, see all of the data in the project list. What did I do wrong?
0
10696
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10782
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10384
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7932
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7093
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5761
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4575
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4174
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3201
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.