Can't open DB. Having problems with MDW file.
Posted on 2005-05-05
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. :)