Re: [mdb-dev] About the mdbtools

[M Y. <me...@gm...>]

Samantha,

I am not a developer of mdb tools, I just use it.  I am not sure how to use
all of the tools in the package.

Give these commands (via command line) a whirl

   -  where {mydatabase.mdb} := the filename of the database
   - and {myfile.txt} := the file you want to save
   - and {mytablename} := is a table you know exists in the database


mdb-schema {mydatabase.mdb} | more
This will give you the complete schema as mdb-tools can read it
or if you would like to save it into a file
mdb-schema {mydatabase.mdb}  > {myfile.txt}

If you need to list the tables you can do

mdb-tables {mydatabase.mdb}

If you need to learn more about a specific tables description you can try

echo "DESCRIBE TABLE {mytablename}" |mdb-sql {mydatabase.mdb} |more

There is also a graphical tool, but its better to get familiar with the
commandline equivalents as I believe it operates as a wrapper (and crashes
every time mdb-tools itself does not gracefully response to a command.

On 3/28/07, Samantha L <sam...@ya...> wrote:
>
>  Hi mdbtools-dev,
>
> Currently I'm using your mdbtools to read mdb file in Linux, and I found
> that not all mdb files can be worked well, if I delete one table from a
> database, and all tables created after this deleted table cannot be read ( I
> used mdb-sql, and the query is "list tables" ), and so does the records.
> When I used "Compact and Repair Database..." to operate on the mdb file,
> then mdb-sql works well, but the working mdb file is very large, and after
> doing compacting and repairing, the file size only changed little, and
> mdb-sql still doesn't work, and the working requirement is I cannot do
> anything in Windows, all in Linux. I really appreciate that if you can fix
> this bug.
>
> Could you please tell me the detailed information about the mdb file
> format, for example, in mdb file, where stores the table name and records,
> are there all in the data page and how can I distinguish them,
> also I got some keys such as "Tables", "Databases", "Relationships",
> "MSysDb", "MSysObjects", "MSysACEs", "MSysQueries", "MSysRelationships",
> "DataAccessPages", "Forms", "Modules", "Reports", "Scripts", "SysRel",
> "AccessLayout", "SummaryInfo", "UserDefined", "MSysAccessObjects",
> "MSysAccessXML", what are these keys exactly meaning, and how can I find
> them? If you can give me the detailed documents about the mdb file format
> and how you decode the mdb file format, I think I can fix the bugs by myself
> much quicklier than knowing less information ( I need to complete this
> project in a very short time ).
>
> If you receive my email, could you please give me a reply, thanks a lot in
> advance!
>
>
>
> Best Regards,
>
> Samantha
>
>
> ------------------------------
> Now that's room service! Choose from over 150,000 hotels
> in 45,000 destinations on Yahoo! Travel<http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--%0A>to find your fit.
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
>


-- 
Mehmet Yilmaz
Chief Software Engineer
Government Services Integrated Process Team