Friday, December 21, 2012

Are you Unable Access Database mdb file? Solution is here...

When I tried to open the .MDB file with MS-Access 2007, it prompted me for a password, but I never created any password for the database. When I tried to leave the password blank, I got following error message: 

“You do not have the necessary permissions to use the mdb object. Have your system administrator or the person who created this object establish the appropriate permissions for you."

I also tried to use the password provided to me on the "one-step security wizard report", but that also did not work & again I got the same error message.

What this error means: 

1.You applied user level security on access database & forgot the password.

2.In most of the cases, this error occurs when you save mdb file in a different program. For example, Microsoft Word permits you to open an Access database, and then to save it.  This may cause the .mdb file to prompt for database password when you again try to open the file in Access database. This occurs although the file may have never been password protected in Access database. In this case, When you try to open mdb file, password prompt occurs because access database checks first byte range. If that byte contains corrupted data, Access treats the file as password protected. 


1. You can remove all user-level security that you previously applied, and then you need to give the Admin user Open/Run Database permission in order to open the MDB database file. If your intent was to keep this database secure, but not apply user-level security on the other databases, then you'll need to join the workgroup that was used to secure the MDB database, give the Admin user a password again, then rejoin the default workgroup, then create a shortcut that opens the MDB database with the appropriate workgroup. Then, you could just use the shortcut to open the MDB database, and you will be prompted for your User ID and password. 

2. If the error occurs due to second reason then the only solution is to restore a backup copy of the file. 

Hope the article will help you to resolve the error “You do not have the necessary permissions to use the mdb object.” You can post your comment and share this article with your friends as well.

No comments:

Post a Comment