Access denied in access database

Posted on 2013-09-26
Medium Priority
Last Modified: 2013-09-27

I am getting message "access denied" in an access database that was created by someone who left the company.

Those with access have added my name with "full control".  However, I still get a message  ,"Access denied - see Manager".

My name is in the user/group listing.  

The one difference I see is that under "inherited from", my name has M:\directory\directory.
Others just have

This database was created by an end user and technical services has tried to figure out what is going on, but we still cannot resolve the problem.

Does anyone have any idea as to what the issue is?
Question by:morinia
LVL 14

Accepted Solution

Bill Ross earned 2000 total points
ID: 39524482

Copy the database to your local desktop and see if it runs OK. If so, then the issue is Network security.  Contact your network admin to set up the security policy correctly.



Author Comment

ID: 39524507
When I first copied it and clicked on it the database opened.  It then gave me the same message.  It appears there must be another validation somewhere that in the database itself. The fact that the message comes up and it does not appear to be an "Access message" but a user message makes me believe this is what is happening.
LVL 59
ID: 39524518
Is this hooked up to SQL Server for storing the data (and it sounds like it)?  If so, it's SQL Server security that needs to be changed.

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

LVL 86
ID: 39524597
Can you post a screenshot of the login form and of the error?

Author Comment

ID: 39524634
I don't get a login screen.  As soon as I click on the access database I get the following message.

Healthfirst Translations Log.
Sorry, access denied. If you need access, please contact Mktg Manager.
LVL 86
ID: 39524649
Okay ... that would be security in the database itself (i.e. something someone added to that database).

Have you contacted "Mktg Manager" to see if you can get access?

You can try holding down the Shift key when opening the database. This will bypass startup codes and such, and might get you further along.

Other than that, we really can't help too much. EE policy won't allow us to help you remove security of any sort.

You wrote:
My name is in the user/group listing.
What listing are you referring to?

Author Comment

ID: 39524663
Thanks experts

I will have someone who has access to the database open it and then I will look into the code to see if I see the code.

Author Closing Comment

ID: 39527473
When I copied the database I was able to get in, however there is internal code that has to be modified to allow me to proceed further.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question