Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Access and "You do not have the necessary permissions

Posted on 2009-02-19
Medium Priority
Last Modified: 2012-05-06
I've seen a few threads about this, but I've brought all info onto one machine and I still cannot get to the data.
We have an access DB in which users can only see forms; I cannot find a way to get to the tables. I want to export the tables either to a new db or Excel.
Now, I've installed the program that creates the db on a stand alone PC.
I've copied the two dbs needed for that program onto that PC.
I can open the program on that PC.
So, what I tried to do is create a shortcut with a path to the mdw and /wrkgrp string, but I get the message "You do not have the necessary permissions blah blah.
The machine has 4 mdws on it.
One with the program, one is Windows folder, One in prog files\common and one from the original location where I pulled the dbs from.
I've tried using all 4 mdws in the shortcut string but to no avail.
When you start the program, you need to enter username, the password is blank. But surely, there must be a way to get to the backend of the db bearing in mind it is all stored on this one machine, I am admin, I can get to all mdws. There must be a way of me getting permissions to the back end.
Any suggestions.
Question by:jasonbournecia
LVL 11

Accepted Solution

mildurait earned 1000 total points
ID: 23679825

Author Closing Comment

ID: 31548685
Thanks for that mildurait,
I tried the demo and it seems good, so will look at purchasing.
Cheers again

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

579 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