473,322 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 1233
zmbd
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
https://support.microsoft.com/en-us/kb/2755119
Dec 17 '15 #2

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

Similar topics

0
by: Mark | last post by:
From VB.Net, I want to open an Access database and run VBA module that resides in the Access database. .Net gives me the error message that Access can't find the VBA Module. 'StartCode Dim...
10
by: vvenk | last post by:
Hello: When I tried to use an Access database, I get the following exception: Server Error in '/WebGrid' Application....
2
by: Enska | last post by:
I have problems connecting my access database I get information .. I cant use my database and I'm administrator on my computer so permission shutnot bee problem, but I dont know Where is the...
0
by: micky | last post by:
=========================================================== Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\SYSTEM'....
4
by: vbie | last post by:
For some reason, I cannot open an Access report in "design" mode anymore. This didn't happen before. However, I can open the design mode of the form, query, table in the same database. Please...
9
by: Matt | last post by:
How would I do this ... I want to set the Windows Scheduler to run the ..bat file which will open an access database at like 2 in the AM. What code do I need in the .bat file.
3
by: ConfusedMay | last post by:
Hi, I've created an access 2003 database that has a form with button called "open complaint database." This complaint database is also in access 2003. Here is my code to open the complaint...
6
by: Killer42 | last post by:
Hi all. I have an application that I wrote ages ago - last compiled in 1998, I believe. It is still in occasional use. It uses an Access database - probably Access version 2, I think. I...
2
by: cdavis | last post by:
Working at non-profit and entering member names(table). system software Vista. Microsoft Access 2007. I am entering data directly into a table (form does not work) and saving the table with a...
1
by: xeLcapytan983x | last post by:
I am trying to create a button in a form that will open a Access database? What is the simplest way to do this, preferably without VBA? What can i put in the command line using the RunApplication...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.