Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

Can't open DB. Having problems with MDW file.

I have a Access database that I need to open. I keep getting the "You don't have the necessary permissions..." error. I can access the data from an old front-end program, but it doesn't have a way to export the data. We need to export the data into a new HR program. The program is FLX Visual HR and it's almost 8 years old.  They were bought by another company and the new company doesn't support it (actually the people I talked to have never heard of FLX visual HR). I have access to the old mdw file. I was able to open the DB a few months ago, but I can't remember how I did it. And of course I forgot to document it, but I didn't think I would need to access it again. Well, good old Murphy stopped by and I need to export the data again.

I know how to join the system.mdw file with workgroup administrator. It shows several users. There doesn't seem to be a password for Admin, but I still get the Permissions error when I try to open the DB file. How do I login as a different user? I remember having to log in as a different user, but I don't remember how.

Are there any other steps that I'm missing? Any help would be greatly appreciated, because I'm pulling my hair out and I can't afford to lose any more. :)


1 Solution
I think your best bet is to find a password crack program for Access.
joew_ksAuthor Commented:
Arji - I've thought about that, but I was able to figure it out before so I wanted to try again with a little help. I think I remember the password, but I can't remember how to login as a different user.
Hi joew_ks,

To log in as a specific user, you can create a command line to start the application:

"pathtomsaccess\msaccess.exe" "pathtodatabase\database.mdb" /wrkgrp "pathtoworkgroupfile\workgroup.mdw" /user "username" /pwd "password"

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

You may try to copy and paste a SYSTEM.MDW from a newly created .mdb where you know the admin pw...

Hope this helps!
joew - please note that we cannot advise you on how to "hack" the database (it's a violation of our member agreements).
joew_ksAuthor Commented:
Thanks to everyone for responding. The answer given by Pete was exactly what I needed and it worked perfectly.

Thanks a million!!


Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now