• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 929
  • Last Modified:

Read Raw ACCDB

I have written a VB.net program that tears down and analyses an ACCDB by using the MS routines.
My question is:
Is it possible to read the ACCDB as a raw input file and analyze it that way.
By parsing or whatever.
I know that Access has a routine that reads all the attributes of the DB and reports them and I'd like to know how it does that.

Thank you for your input.

Jerry
0
Donna Kainer
Asked:
Donna Kainer
3 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Jerry,

  Possible?  Certainly yes.  Easy no?

  No because the JET/ACE database structure has never been fully documented.  Obviosuly all  the companies out there offering recovery services have mangaed to figure it out, so it is doable.

  But I would suspect that its taken them hundreds of man-hours to do that.

JimD.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<Is it possible to read the ACCDB as a raw input file and analyze it that way>
Depends on what you mean by "Analyze"
;-)

You can certainly open any raw Accdb file in notepad and use: Edit-->Find to search for certain words.

But to extract anything meaningful from this format without explicit consent would be considered borderline "Hacking"

JeffCoachman
untitled.JPG
0
 
BitsqueezerCommented:
Hi,

the question is: What are you missing? The Microsoft libraries offers you access to anything you want using the Interoperability libraries, a start is here:

Creating Managed Add-ins for Access 2007

So why should one try to identify anything on binary base? This would be a horrible job and I don't think it will be successful. Maybe there's not everything documented using the standard methods, but I think with a little bit experimenting it should be possible to find out all the properties you need (not with the binary data, of course) using the Interop methods.

Cheers,

Christian
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Donna KainerAuthor Commented:
I was hoping to find whether somebody has figured out the ACCDB structure.  Hacking is not my purpose.
My curent routine uses the MS Routines to loop thru all Tables, Forms, Modules, etc and extracts relevant properties and code.  But this takes time.  I was hoping a more direct approach would be quicker.  Maybe I'm shooting for the moon.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I was hoping to find whether somebody has figured out the ACCDB structure. >>

  Not that anyone has shared.  There was an effort a number of years ago to figure out the structure, but it was far from complete and it only covered JET.  The new ACE format didn't exist back then.


<<My curent routine uses the MS Routines to loop thru all Tables, Forms, Modules, etc and extracts relevant properties and code.  But this takes time.  I was hoping a more direct approach would be quicker.>>

  Well I don't see how you are going to achieve that quicker by doing it yourself.  It's still going to take time to go through a DB structure whether you do it or Microsoft does.   DAO's been around a long time, so I doubt there is anything in it that's not optimized at this point.

  Maybe you could make some gains, but I'd highly doubt they'd be drastic ones.

  And one other thing; your talking about more then just the JET/ACE DB structure.  Access objects are stored as BLOB fields in JET, so you'd need to figure out their interal structures as well.

<<Maybe I'm shooting for the moon. >>

  Honestly you are.  Just use DAO.

JimD.

0
 
Donna KainerAuthor Commented:
All three were helpful and helped me to leave things as they are.  I always wondered whether it was possible to do this and now I know it is, but the time to figure it out would not be worth it.

Thank you
0
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now