[ILUG] Re: Locked M$ DB

[Marcus Furlong]

Sonic wrote:

> Hi there,
> 
> Does anyone know how to unlock a M$ access db file. My mate has managed
> to forget the password (or set it wrongly as he put it) for a database
> which contains all his other passwords. I don't really use access so all
> I can tell you is that when I try to open it I get a message saying I
> don't have permission to open it.

I remember using the following script a good while ago and it worked then,
but I remember it didn't work on the newest Office files:

http://groups.google.com/group/alt.ph.uk/browse_frm/thread/36d52844933fa092/a395444b986bab5f?tvc=1&q=Lensman+access#a395444b986bab5f

Another option is to overwrite the workgroup file (contains all valid users
etc). Create a new database with new users (similar usernames and groups if
possible), then find the workgroup file (.mdw I think) and overwrite the
original. I've got the feeling I may have left out some step along the way,
sorry but it's been a while, anyway some variation of the above worked for
me too.

P.S. When you do get it done, the next step is to run
convert-Access-to-MySQL script
(http://www.kofler.cc/mysql/msacc2mysql.txt :-)