Access and "You do not have the necessary permissions

Posted on 2009-02-19
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


    Author Closing Comment

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

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now