List of Users

[Dates]

I'm trying to build an Access User List for a DB. I have read the 2 posts on
the subject and have gone to the link provided. I'm still having trouble
with this GUID? I'm not exactly sure what I need to build or even how to
create it? Any ideas

 

[Rick B]

What do you mean by an Access User List? Users are set up in the Security.

Have you secured your database?


Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

 

[Dates]

Rick,

Sorry... What I meant is. I want to know who is currently in the Database.

 

[carlos Tipa]

Maybe you need to know who users are connecting in your database (jet 4.0
perhaps) if is that, review this article of the MS Knowlegde Base:
http://support.microsoft.com/kb/198755/EN-US/
Working for Acces 2000

Carlos Tipa.

 

[Van T. Dinh]

If you are referring to the Microsoft Knowlwdge Base article:

http://support.microsoft.com/?id=198755

then it works fine for me (tested on WXP SP2, A2002, ADO 2.7).

Make sure you have ADO 2.1 later in the References.

 

[Arvin Meyer [MVP]]

You can easily find out who is logged into anything on a server by
right-clicking on "My Computer" choosing "Manage" then "Shared Folders" then
"Open Files" and you'll see every shared file in use on that machine, along
with the logged in username of anyone connected to it. You can use Terminal
Services to connect to the server or do it locally (assuming you have
permissions).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Dates]

I am aware of the website http://support.microsoft.com/kb/198755/EN-US. I
guess I'm having trouble with creating the GUID. I've tried following the
instructions on website, but it is still confusing to me.

 

[Van T. Dinh]

The code in the article works fine. See my earlier post in this thread.

 

[Dates]

Van,

This part of the code I'm having trouble with. The user roster is exposed
as a provider-specific schema rowset
' in the Jet 4 OLE DB provider. You have to use a GUID to
' reference the schema, as provider-specific schemas are not
' listed in ADO's type library for schema rowsets. How do you create
the GUID or the schema? I've looked on the msft website, I have found the
link with the walkthroughs, but it is not very clear.

Thanks
Dates

 

[Dates]

Van,

Adding to my previous post. I have found the section that shows how you
create the GUID
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bpsdk/BPIG_AppA_GUID.asp

My ? is, How do you Open the Visual Studio. NET command prompt?
The instructions are there on the website, the problem is getting past the
first step.

Thanks Again
Dates

 

[Van T. Dinh]

I used *exactly* the same GUID as posted in the code in the article. I
think it is the GUID of ADO Library.

I don't even have VS.Net installed ...

 

[Brendan Reynolds]

On my system ...

Start
All Programs
Microsoft Visual Studio .NET 2003
Visual Studio .NET Tools
Visual Studio .NET 2003 Command Prompt

Details may differ depending on your version of Windows and of Visual
Studio, and whether you accepted or changed the default choices when
installing Visual Studio.

 

[Dates]

Hi All,

Thanks for your posts. I found a much much simplier way to discover who is
in the database. I did some searching on Google. I found this website
http://www.tek-tips.com/faqs.cfm?fid=4894

This code is much simplier.

Thanks
Dates