[mdb-dev] Opening .mdb without .mdw?

[David Ackerman]

Hi,

My name is David Ackerman and I have been trying to use mdb-tools to
open a recovered .mdb access database. The database is not able to be
opened in any versions of access, due to privilege problems. My
coworkers and I have narrowed the problem down to a missing .mdw, or
workgroup file, that access uses to store user and security
information. It seems that we cannot open this database without the
workgroup file. I have tried using mdb-export, to convert the file to
csv tables and reimport them into a new database, but I am unable to
do this because mdb-tables gives me the error that the file is not a
proper database file. Mdb-tools recognizes the file as a jet4 database
and we have no reason to believe it has been corrupted, though, so it
is probably due to the missing mdw file. I am wondering if mdb-tools
is the right software for me to be using to try and get around this
privileges issue, and if so, what the recommended way of going about
it would be. I appreciate any input on this issue.

Thank You,
David Ackerman

[Dmitry Nikitin]

Hi!
I think it`s posible.
Try the command line interface:
mdb-schema --drop-table {name_of_file}.mdb mysql > shema.sql
mdb-export -I mysql -D '%Y-%m-%d' -q \' -X \\ {name_of_file}.mdb "{name_of_tables-find_in_file-shema.sql}">> database.sql
See the results in files as mysql database. Or try commands for cvs format.

Good luck, Dmitry

On Fri, 22 Jun 2012 10:47:48 -0400

Post by David Ackerman
Hi,
My name is David Ackerman and I have been trying to use mdb-tools to
open a recovered .mdb access database. The database is not able to be
opened in any versions of access, due to privilege problems. My
coworkers and I have narrowed the problem down to a missing .mdw, or
workgroup file, that access uses to store user and security
information. It seems that we cannot open this database without the
workgroup file. I have tried using mdb-export, to convert the file to
csv tables and reimport them into a new database, but I am unable to
do this because mdb-tables gives me the error that the file is not a
proper database file. Mdb-tools recognizes the file as a jet4 database
and we have no reason to believe it has been corrupted, though, so it
is probably due to the missing mdw file. I am wondering if mdb-tools
is the right software for me to be using to try and get around this
privileges issue, and if so, what the recommended way of going about
it would be. I appreciate any input on this issue.
Thank You,
David Ackerman
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
mdbtools-dev mailing list
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev