Reverse Engineering the Access Database

[pavan kokkiragedda]

Hi could anyone help me in reverse engineering the existing MSAccess Database(2002-2003 file format) to get the data model?
Thanks in Advance.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Albert D. Kallal]

Could you expand a bit on the actual problem you have?

There are tools built into ms-access to help you in this regards. Have you
looked at the relationships window, as it can help you with the data model
(and, can graphically represent the data model).

From the main menu, go

tools->relationships

There is also the database documenter, and it can printout the table names,
and fields information also.
tools->analyse->documenter

 

[Tony Toews]

Hi could anyone help me in reverse engineering the existing MSAccess Database(2002-2003 file format) to get the data model?

MDB Tools is a set of open source libraries and utilities to
facilitate exporting data from MS Access databases (mdb files) without
using the Microsoft DLLs. In other words they are reverse engineering
the layout of the MDB file. mdbtools.sourceforge.net

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm