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 :-)
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
