Solved

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

Posted on 2008-10-30
12
3,932 Views
Last Modified: 2010-04-21
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?
0
Comment
Question by:cindyrowe
  • 6
  • 4
  • 2
12 Comments
 
LVL 75
ID: 22847911
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
 
LVL 75
ID: 22847942
Ok ... it looks like it DOES work with A2007 ... but read the 'Known Issues' on the page of the link I supplied.

mx
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 22849453
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
 
LVL 75
ID: 22851358
Or ... you can use Frank's ldb viewer ... which is free and does all of that ... and a lot more :-)

mx
0
 

Author Closing Comment

by:cindyrowe
ID: 31511947
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
 
LVL 57
ID: 22852071
<<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
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 75
ID: 22852215
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
 

Author Comment

by:cindyrowe
ID: 22852968
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
 
LVL 75
ID: 22852989
Do you mean missing something in Frank's ldb viewer ?

mx
0
 

Author Comment

by:cindyrowe
ID: 22853014
Yes
0
 
LVL 75
ID: 22853249
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
 

Author Comment

by:cindyrowe
ID: 22855290
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now