I need an ldb viewer for access 2007. A viewer (shows users accessing the database) was provided with Jetutils for Access 2003.

The Jetutils download from Microsoft provided an executable that allowed me to see user using a particular data base.  It does not work with accdb Access data bases (Office 2007).  Is there a replacement?
cindyroweAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I use this daily - all day. It's free and 100 times better that the MS LDB viewer:

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

Not sure if it will work with A2007 ... but it might.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Ok ... it looks like it DOES work with A2007 ... but read the 'Known Issues' on the page of the link I supplied.

mx
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
FWIW, just so you understand what that utility is doing:

A.  You can read the .LDB file directly, but that will only give you the username and computer name and will not indicate who is in the DB.  In order to do that, you need to look at the current user locks.  It will also not show you the corrupt flag, which is stored in the database header page.  so...

B.  You can use the functions in the MSLDBUSR.DLL

  or

C.  You can use the ADO User Roster Schema.

  or

D.  You can poll the OS for lock info (no one has ever bothered to do this yet though).

  I mention this in case you want to build the functions your looking for into an existing app.

JimD.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Or ... you can use Frank's ldb viewer ... which is free and does all of that ... and a lot more :-)

mx
0
cindyroweAuthor Commented:
My specific goal was to find a viewer for laccdb files as opposed to ldb files.  (Access 2007 vs. 2003).  While the reference to the Technipixel viewer provided information on Access 2007 in the "known issues" and I installed it - it didn't provide the ability to actually open an laccdb file - just an ldb.  So I went the route of the ADO User Roster Schema which absolutely works - however, it appears I'll need to add it to every data base individually in order to use it - which is ok, but not ideal.  I'll continue to work on it over the weekend.  For now, I'm happy to put it into a couple I need to poll regularly.  Thank you!
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Or ... you can use Frank's ldb viewer ... which is free and does all of that ... and a lot more :-)>>

  I'm not sure about the "lot more", but the point was if he wanted to build it into his existing apps, then there is nothing in that app that he could not do himself.

  The LDB viewer program is a standalone.  If he can live with that, then he'd be crazy to do it all over again, but some do like to learn through doing and might do one anyway.

FWIW
JimD.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I'm a little confused here:

Question:

"I need an ldb viewer for access 2007."

Answer (and free):
http://www.technipixel.com/accessldb.htm

And it does work with A2007.

??

mx

0
cindyroweAuthor Commented:
Maybe it's me that's confused or missing something simple.  When I try to add an accdb data base, I don't get choices in the File Type for anything but mdb, mde and can't browse to the accdb I want to see.  Am I missing something?
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Do you mean missing something in Frank's ldb viewer ?

mx
0
cindyroweAuthor Commented:
Yes
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Email Frank and point that out. I don't have A2007.  I've been using it daily with A2002 - to monitor 16 mdb's on a server. I added the Device ID's of approx 100 users and their names - so, it displays the Device ID AND the user name.  It's really very cool.

I'm going to email him and request a few mods, which I am will in to pay for.

mx
0
cindyroweAuthor Commented:
I agree - it's really cool - I tried it on an mdb.  It would be nice if it could see the accdbs.  I'll email him.  Thanks again!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.