MS Access 2003 -- "don't have necessary permissions..."
Posted on 2011-02-23
I am getting that nasty "You don't have the necessary permissions to use..." message for just one of the 20 or so Access databases I'm responsible for maintaining (I'm part of the Admin user group). I have no problem opening up any of the other databases.
A colleague of mine (an experienced Access user who no longer works in-office) believes it might be a case of this database using a different security file. She suggested gaining access to the database with the help of a current user, going into the database administrator menu and pointing the secured file to the shared one that was set up. Unfortunately, she doesn't recall the specific steps.
I've opened up another Access database to look for this db admin menu, but I don't see it. The closest option that comes to it is Workgroup Administrator, but nowhere can I specify the name of our shared file. Does anyone know the specific steps she is referring to? Thanks.