471,874 Members | 1,806 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,874 software developers and data experts.

Cannot open secured Access database

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 1169
5,501 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
Dec 17 '15 #2

Post your reply

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

Similar topics

reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.