Who is logged on to our Access database

[Guest]

Hi,

I have an Access database that users have to log onto (name & password). Is
there any way I can see which users are currently logged on?

Thanks,

- Mark

 

[Granny Spitz via AccessMonster.com]

Is
there any way I can see which users are currently logged on?

Check the user roster or use the LDB Viewer:
http://support.microsoft.com/default.aspx?id=285822

 

[aaron.kempf]

ROFL

if you were using Access Data Project; then you would just need to run
sp_who2

ROFL

MDB is so obsolete; it makes me sick to think that you kids still use
it for anything.
Not for a single record and a single user.

-Aaron

 

[Guest]

Hey Granny,

Thank you so much. I tried this, and followed the isntructions as set out
ion the article. But, when I try to run the module I get an error right at
the very first line:

Dim cn As New ADODB.Connection

I get the error 'User-defined Type Not Defined'. What do you suggest I do now?

Thanks again for your help,

- Mark

 

[aaron.kempf]

Add 'Microsoft ActiveX Data Objects' version 2.6 (or greater)

something along those lines

TOOLS, REFERENCES; scroll down until you can see that line item.

-Aaron

 

[Granny Spitz via AccessMonster.com]

I get the error 'User-defined Type Not Defined'.

You don't have the ADO library referenced in your current VBA project. Open
the code window then Tools | References and scroll down to and mark Microsoft
ActiveX Data Objects 2.X Library. Save the change and compile the code. Now
try to run the procedure again.

 

[Guest]

Wonderful! It works perfectly. Thank you.

You are as wise as you are beautiful, Granny.

- Mark

 

[Granny Spitz via AccessMonster.com]

Wonderful! It works perfectly. Thank you.

You are as wise as you are beautiful, Granny.

<blush> You're welcome, Mark. I'm glad it worked so well for you!

 

[aaron.kempf]

for the record; this is one post that I answered correctly before
anyone else but I didn't get credit for it-- BECAUSE MICROSOFT CENSORS
POSTS ON A PUBLIC NEWSGROUP


-Aaron