asked on

Know who's logged into MS ACCESS database Access 2k7

I have seen this asked, but haven't found it successfully answered.

I need to know who is logged into an MSACCESS 2007 database.

I found a piece of code, but it was for Acc2000 and I got errors when attempting it on Acc2k7.

Anyone got a great solution?

Tony

Graham Mandeno

This method should still work in Access 2007:
http://support.microsoft.com/kb/198755
--
Graham

ASKER CERTIFIED SOLUTION

datAdrenaline

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

Brent and Graham,

You guys going to the MVP Conference?

Scott

datAdrenaline

Hello Scott,

I, unfortunately, can not. I made a committment for that time frame BEFORE i knew when the conference was going to be ... go figure.

I REALLY wanted to go this year too ...

Brent

Graham Mandeno

Hi Scott
Unfortunately not - I just can't afford the $3K+ in air fares when the roof needs fixing :-(
Have fun, and have a drink (or several) for me :-)
--
Graham

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

This is pretty cool and I use it daily to monitor approx 22 back ends here at work .. Frank Hilton's Access LDB Viewer:

http://www.technipixel.com/accessldb.htm

** Unfortunately ... as I found out last night, it is no longer available ... but since it was free, I am uploading it.

See attached image - had to black out some info ... but you'll get the idea.

It's very cool ...because wherein it's a VB app ... there is an MDB that he uses ... therefore, you can load additional info into the mdb ... like the user name etc related to the Device ID.

mx

FrankHiltonsLdbViewer.jpg
FrankHilton-AccessLDBSetup.zip

TIgerV

ASKER

Thanks! Much appreciation for your help!

TIger