469,076 Members | 1,915 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

Cannot open secured Access database

1
A user is having problem opening an Access database after installing Office 365. I tried to open my older test copy with Office 365 Access but go the message "You do not have the necessary permissions to use the 'G:CSS-IRM\Access Applications\Landuse.mdb'object. Have your system administrator or the person who created this object establish the appropriate permissions for you." I believe I was previously able to open the database but may be wrong. the original creator is long gone and I had our Domain administrator give administrative privileges to several users for the database. And made sure the database was Trusted. Still unable to open the database with the same message. I do see a system.mdw file. I opened it with Access I get Queries: MSysGroupList, Name column with Admins and Users; MySysGroupMembers, double click brings up a screen to enter a group name but not allowed; MSysUserList, Name column, with admin, Creator, Engine; MSysUserMemberships,double click brings up a screen to enter a UserName but not allowed;
Need to know how I can get access to the database so can resolve user problem.
Dec 16 '15 #1
1 1111
zmbd
5,400 Expert Mod 4TB
The ACC2003 and older databases used the system.mdw, or a custom dot-mdw file, to implement user level security.

You best option will be to open the database on a PC that has same version of access and the system.mdw used to create the database.

There are various methods of bypassing this basic level of security; however, we do not usually discuss this here because we're unable to verify that an individual is the rightful or authorized owner/user of the database.

Another issue you might run in to is the age of the database. Acc2013 will not open Acc97 and soon other MDB types files
https://support.microsoft.com/en-us/kb/2755119
Dec 17 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

By using this site, you agree to our Privacy Policy and Terms of Use.