I am stuck working with what I believe is a very old access database (I think it's access 2.0) that I am struggling to open.
I have a program front-end that interfaces with this database. When I launch the program front-end it prompts me for a user name and password, which I enter, then the program opens and I can access the data from within the program.
However, when I try to open the access database directly, I receive this error:
I did some searching and found this is usually related to workgroup security and involves a system.mdw file. I have tried searching my entire computer for this file and cannot find it.
You do not have the necesary permission to use the "my_database.mdb' object. Have your system administrator or the person who created this object establish the appropriate permission for you.
I am able to open the database via the front-end application using the user name and password, but unfortunately this program does not allow me to export the data.
The bottom line is the front-end application is being sunsetted, and I need to extract the information from this database. I've also tried to attach the .mdb file as an ODBC source and connect to it, but again I received this same error. I've also tried opening a new database in Access and importing from the old file, but again I got the error.
It is imperative that I retrieve this data. If anyone has any ideas, I would be very appreciative. Thank you very much.