Access denied in access database

Experts,

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
M:\

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?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill RossProgrammerCommented:
Hi,

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.

Regards,

Bill
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
moriniaAdvanced Analytics AnalystAuthor Commented:
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.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.

Jim.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you post a screenshot of the login form and of the error?
0
moriniaAdvanced Analytics AnalystAuthor Commented:
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.
---------------------------
OK  
---------------------------
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?
0
moriniaAdvanced Analytics AnalystAuthor Commented:
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.
0
moriniaAdvanced Analytics AnalystAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.